APPS.AP_INVOICES_UTILITY_PKG dependencies on PO_HEADERS

Line 990: po_headers PH

986: CURSOR po_number_cursor IS
987: SELECT DISTINCT NVL(ph.CLM_DOCUMENT_NUMBER , ph.segment1), ph.po_header_id, -- for CLM Bug 9503239
988: NVL(SUM(L.amount),0)
989: FROM ap_invoice_lines_all L,
990: po_headers PH
991: WHERE L.invoice_id = l_invoice_id
992: AND L.po_header_id = PH.po_header_id
993: AND L.match_type IN ( 'PRICE_CORRECTION', 'QTY_CORRECTION',
994: 'ITEM_TO_PO', 'ITEM_TO_RECEIPT', 'AMOUNT_CORRECTION',

Line 1244: po_headers PH

1240:
1241: CURSOR po_number_cursor IS
1242: SELECT DISTINCT(NVL(ph.CLM_DOCUMENT_NUMBER , ph.segment1)) -- for CLM Bug 9503239
1243: FROM ap_invoice_lines L,
1244: po_headers PH
1245: WHERE L.invoice_id = l_invoice_id
1246: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1247: FROM ap_invoice_lines AIL
1248: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'

Line 3771: FROM po_headers PH

3767: l_po_number VARCHAR2(50) := NULL;
3768:
3769: CURSOR int_po_number_cursor IS
3770: SELECT NVL(ph.clm_document_number, ph.segment1)
3771: FROM po_headers PH
3772: WHERE ph.segment1=p_po_number
3773: AND ph.org_id=p_org_id;
3774:
3775: BEGIN