APPS.POR_CANCEL_NOTIF_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 124: po_requisition_headers_all prh,

120:
121: select nvl(prh.supplier_notified_flag, 'N'), prl.contractor_status
122: into l_supplier_notified_flag, l_contractor_status
123: from
124: po_requisition_headers_all prh,
125: po_requisition_lines_all prl
126: where
127: prh.requisition_header_id = prl.requisition_header_id and
128: requisition_line_id = l_req_line_id;

Line 245: po_requisition_headers_all prh,

241: SELECT pja.job_description, prl.contact_information,
242: prl.assignment_start_date, prh.segment1 || ' / ' || to_char(prl.line_num)
243: INTO l_job_name, l_contact_info, l_start_date, l_req_info
244: FROM
245: po_requisition_headers_all prh,
246: po_requisition_lines_all prl,
247: po_job_associations pja
248: WHERE prl.requisition_line_id = l_req_line_id AND
249: prl.job_id = pja.job_id AND