DECLARE @REQ_DT DATETIME,@REQ_ID VARCHAR(20)
SET @REQ_DT = (SELECT REQ_DT FROM dbo.PL_REQUEST_DOC  WHERE REQ_CODE='0003/2020/TTr-0020005')
SET @REQ_ID = (SELECT REQ_ID FROM dbo.PL_REQUEST_DOC  WHERE REQ_CODE='0003/2020/TTr-0020005')


UPDATE dbo.PL_REQUEST_DOC SET APPROVE_DT=@REQ_DT,EFFEC_DT=@REQ_DT WHERE REQ_ID=@REQ_ID
UPDATE dbo.PL_REQUEST_PROCESS SET APPROVE_DT= @REQ_DT WHERE REQ_ID=@REQ_ID AND STATUS='P'