DECLARE @REQ_ID VARCHAR(15), @REA_REASON NVARCHAR(250)
SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='032021/000644')
SET @REA_REASON =(SELECT REQ_REASON FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='032021/000644')

UPDATE TR_REQ_PAY_SCHEDULE SET REQ_PAY_DESC =@REA_REASON, REQ_PAY_ENTRIES = @REA_REASON WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_BUDGET SET REASON =@REA_REASON WHERE REQ_PAY_ID =@REQ_ID

UPDATE TR_REQ_PAY_METHOD SET REQ_PAY_DESC =@REA_REASON, REQ_PAY_REASON = @REA_REASON, REQ_PAY_ENTRIES = @REA_REASON WHERE REQ_PAY_ID =@REQ_ID