UPDATE
    C
SET
	C.VLR_PROD_TOT = XML_CAB.VLR_TOT_PROD
FROM 
    EST_NF_ENT_DANFE_PROVISORIO C
    INNER JOIN EST_NF_ENT_DANFE_PROVISORIO_PENDENTE ON
	C.CD_CTR = EST_NF_ENT_DANFE_PROVISORIO_PENDENTE.CD_CTR 
	OUTER APPLY UFD_EST_NF_ENT_DANFE_PROVISORIO_DADOS_DO_XML (C.CD_CTR,1,0) XML_CAB
WHERE
	C.VLR_PROD_TOT <> XML_CAB.VLR_TOT_PROD