322: select projects.segment1
323: into value
324: from
325: po_req_distributions_all prd,
326: pa_projects_all projects
327: where
328: prd.requisition_line_id = req_line_id and
329: projects.project_id = prd.project_id and
330: rownum = 1;
940: select projects.segment1
941: into project_number
942: from
943: po_req_distributions prd,
944: pa_projects projects
945: where
946: prd.requisition_line_id = req_line_id and
947: projects.project_id = prd.project_id and
948: rownum = 1;