DECLARE @req_id varchar(20),@date DATETIME
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000248'
SELECT @date = pac.REQ_DT FROM PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_ID = @req_id
SELECT * FROM PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_ID = @req_id
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @req_id
SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT id FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @req_id)
SELECT * FROM PL_PROCESS WHERE REQ_ID = @req_id
SELECT @date