declare @REQ_DOC_ID VARCHAR(15)='', @PL_REQ_ID VARCHAR(15)=''
SET @REQ_DOC_ID = (select top(1) REQ_DOC_ID from TR_CONTRACT where CONTRACT_ID = 'TRC000000254168')
SET @PL_REQ_ID = (select TOP(1) PL_REQ_ID from TR_REQUEST_DOC WHERE REQ_ID = @REQ_DOC_ID)
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID = @REQ_DOC_ID
SELECT * FROM TR_CONTRACT WHERE CONTRACT_ID = 'TRC000000254168'
SELECT * FROM TR_CONTRACT_DT WHERE CONTRACT_ID = 'TRC000000254168'
select * from PL_REQUEST_DOC WHERE REQ_ID = @PL_REQ_ID
select * from PL_REQUEST_DOC_DT WHERE REQ_ID = @PL_REQ_ID
select * from PL_TRADEDETAIL TRADE WHERE EXISTS(Select * from PL_REQUEST_DOC_DT DT WHERE REQ_ID = @PL_REQ_ID AND DT.TRADE_ID = TRADE.TRADE_ID)