declare @REQ_ID VARCHAR(15) SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2023/000171' select * from PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_ID select * from PL_PROCESS WHERE REQ_ID = @REQ_ID