DECLARE @req_id varchar(15) SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'Pur/2023/000749' SELECT pac.REPORT_TEMPLATE_CONTENT FROM PL_APPOINT_CONTRACTOR pac WHERE pac.TR_REQUEST_DOC_ID = @req_id