DECLARE @REQ_PAY_ID VARCHAR(20), @REQ_PAY_CODE VARCHAR(20) = ''
SET @REQ_PAY_ID = (SELECT TOP 1 REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = @REQ_PAY_CODE)

select * from TR_REQ_PAYMENT WHERE REQ_PAY_ID = @REQ_PAY_ID
SELECT * FROM TR_REQ_ADVANCE_DT WHERE REQ_PAY_ID = @REQ_PAY_ID
SELECT * FROM TR_REQ_PAY_PERIOD WHERE REQ_PAY_ID = @REQ_PAY_ID
SELECT * FROM TR_REQ_PAY_METHOD WHERE REQ_PAY_ID = @REQ_PAY_ID
SELECT * FROM TR_REQ_PAY_ENTRIES WHERE REQ_PAY_ID = @REQ_PAY_ID
SELECT * FROM PAY_ENTRIES_POST WHERE TRN_ID = @REQ_PAY_ID 
select * from TR_REQ_PAY_TRANS_OUTSIDE_REC where REQ_PAY_ID = @REQ_PAY_ID
select * from TR_REQ_PAY_TRANS_OUTSIDE_TRANS where REQ_PAY_ID = @REQ_PAY_ID


DECLARE @REQ_PAY_AUTO_ID VARCHAR(20), @REQ_PAY_AUTO_CODE VARCHAR(20) = ''
SET @REQ_PAY_AUTO_ID = (SELECT TOP 1 REQ_PAY_AUTO_ID FROM TR_REQ_PAYMENT_AUTO WHERE REQ_PAY_AUTO_CODE = @REQ_PAY_AUTO_CODE)

select * from TR_REQ_PAYMENT_AUTO WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID
SELECT * FROM TR_REQ_PAY_AUTO_SCHEDULE WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID
SELECT * FROM TR_REQ_PAY_AUTO_SCHEDULE_DETAIL WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID
SELECT * FROM TR_REQ_PAY_AUTO_METHOD WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID
SELECT * FROM TR_REQ_PAY_AUTO_ENTRIES WHERE REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID
select * from TR_REQ_PAY_AUTO_TRANS_OUTSIDE_REC where REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID
select * from TR_REQ_PAY_AUTO_TRANS_OUTSIDE_TRANS where REQ_PAY_AUTO_ID = @REQ_PAY_AUTO_ID