SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/001374')

SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/001374')