DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID=(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='042022/000397')
SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID=@REQ_ID
SELECT * FROM TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID=@REQ_ID
SELECT * FROM TR_REQ_PAY_SCHEDULE WHERE REQ_PAY_ID=@REQ_ID
SELECT * FROM TR_REQ_PAY_METHOD WHERE REQ_PAY_ID=@REQ_ID
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID=@REQ_ID
---202248