APPS.PON_AUCTION_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 9830: from po_requisition_headers_all prha

9826: and source_type_code <> 'INVENTORY'
9827: and NVL(line_location_id, -999) = -999
9828: and not exists
9829: (select 'Req Header auth_status is not approved or contractor_status is pending'
9830: from po_requisition_headers_all prha
9831: where prha.requisition_header_id = prla.requisition_header_id
9832: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
9833: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING'));
9834: END IF;

Line 17380: from po_requisition_headers_all prha, PON_BACKING_REQUISITIONS pbr

17376:
17377:
17378: CURSOR preparer_list IS
17379: select prha.preparer_id
17380: from po_requisition_headers_all prha, PON_BACKING_REQUISITIONS pbr
17381: where pbr.auction_header_id = x_auction_header_id
17382: and prha.requisition_header_id = pbr.requisition_header_id;
17383:
17384:

Line 17801: FROM po_requisition_lines_all l, po_requisition_headers_all h

17797: FOR j in 1..p_requisition_line_id.COUNT LOOP
17798:
17799: SELECT h.requisition_header_id, h.segment1
17800: INTO l_req_header_id, l_req_number
17801: FROM po_requisition_lines_all l, po_requisition_headers_all h
17802: WHERE requisition_line_id = p_requisition_line_id(j)
17803: and h.requisition_header_id = l.requisition_header_id;
17804:
17805: BEGIN