APPS.POR_CANCEL_NOTIF_PVT dependencies on PO_REQUISITION_HEADERS

Line 96: l_supplier_notified_flag po_requisition_headers.supplier_notified_flag%type;

92: resultout out NOCOPY varchar2)
93: IS
94:
95: l_progress varchar2(200);
96: l_supplier_notified_flag po_requisition_headers.supplier_notified_flag%type;
97: l_req_line_id NUMBER;
98: l_contractor_status po_requisition_lines.contractor_status%type;
99: l_api_name varchar2(50) := 'IS_ANY_SUPPLIER_NOTIFIED';
100: BEGIN

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