/*Atualizar propostas de acordo com o mes do cliente*/

UPDATE PROPOSTAFAS P
SET P.NRMESREAJPROP = (SELECT C.NRMESREAJCLIE
                       FROM CLIENTE C
                       WHERE C.CDCLIENTE = P.CDCLIENTE
                         AND C.NRMESREAJCLIE IS NOT NULL)
/

UPDATE CONTRATOLINP CT
SET CT.NRMESREAJCONT = (SELECT C.NRMESREAJCLIE
                       FROM CLIENTE C
                       WHERE C.CDCLIENTE = CT.CDCLIENTE
                         AND C.NRMESREAJCLIE IS NOT NULL)
/

UPDATE CONTRATOSERV CS
SET CS.NRMESREAJSERV = (SELECT C.NRMESREAJCLIE
                       FROM CLIENTE C
                       WHERE C.CDCLIENTE = CS.CDCLIENTE
                         AND C.NRMESREAJCLIE IS NOT NULL)
/
COMMIT
/



