DECLARE @req_id varchar(20)
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000248'
SELECT * FROM PL_APPOINT_CONTRACTOR pac WHERE pac.TR_REQUEST_DOC_ID = @req_id