DECLARE @req_id varchar(20)
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000572'
SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000572'

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)