APPS.PO_AP_MERGE_GRP dependencies on PO_HEADERS_ALL

Line 87: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

83: -- p_vendor_site_code IN PO_VENDOR_SITES_ALL.vendor_site_code%TYPE
84: -- ) RETURN BOOLEAN;
85: --
86: --FUNCTION referencing_asl_exist
87: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
88: -- p_call_from IN VARCHAR2
89: --) RETURN BOOLEAN;
90: --
91: --FUNCTION referencing_docs_exist

Line 92: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

88: -- p_call_from IN VARCHAR2
89: --) RETURN BOOLEAN;
90: --
91: --FUNCTION referencing_docs_exist
92: --( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
93: --) RETURN BOOLEAN;
94: --
95:
96: --

Line 331: FROM po_headers_all GA,

327: INTO l_pass_val
328: FROM dual
329: WHERE EXISTS (
330: SELECT NULL
331: FROM po_headers_all GA,
332: po_ga_org_assignments PGOA
333: WHERE GA.global_agreement_flag = 'Y'
334: AND GA.vendor_id = p_from_vendor_id
335: AND GA.po_header_id = PGOA.po_header_id

Line 371: po_headers_all GA

367: WHERE EXISTS (
368: SELECT NULL
369: FROM po_headers POH,
370: po_lines POL,
371: po_headers_all GA
372: WHERE POH.vendor_id = p_from_vendor_id
373: AND POH.vendor_site_id = p_from_site_id
374: AND POH.po_header_id = POL.po_header_id
375: AND GA.po_header_id IN (POL.contract_id,

Line 412: po_headers_all GA

408: FROM dual
409: WHERE EXISTS (
410: SELECT NULL
411: FROM po_requisition_lines RL,
412: po_headers_all GA
413: WHERE RL.vendor_id = p_from_vendor_id
414: AND RL.blanket_po_header_id = GA.po_header_id
415: AND GA.global_agreement_flag = 'Y'
416: AND GA.org_id <> RL.org_id);