APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 2198: from ap_invoice_payments_all aip,

2194: if (l_count > 0) then
2195: BEGIN
2196: select ac.check_id
2197: into l_check_id
2198: from ap_invoice_payments_all aip,
2199: ap_checks_all ac
2200: where aip.check_id=ac.check_id
2201: and aip.accounting_event_id = l_accounting_event_ids(i)
2202: and aip.invoice_id=l_event_source_info.source_id_int_1;

Line 2801: from ap_invoice_payments_all aip,

2797: if (l_count > 0) then
2798: BEGIN
2799: select ac.check_id
2800: into l_check_id
2801: from ap_invoice_payments_all aip,
2802: ap_checks_all ac
2803: where aip.check_id=ac.check_id
2804: and aip.accounting_event_id = l_accounting_event_ids(i)
2805: and aip.invoice_id=l_event_source_info.source_id_int_1;

Line 3732: FROM ap_invoice_payments_all AIP2,

3728: SET D.accounting_event_id = p_event_id
3729: WHERE D.accounting_event_id IS NULL
3730: AND D.invoice_id IN
3731: (SELECT AI.invoice_id
3732: FROM ap_invoice_payments_all AIP2,
3733: ap_invoices_all AI
3734: WHERE AI.invoice_id = AIP2.invoice_id
3735: AND AIP2.check_id = p_check_id
3736: AND AIP2.accounting_event_id = p_event_id

Line 3880: FROM ap_invoice_payments_all AIP,

3876: SET AID.accounting_event_id = l_accounting_event_ids(i)
3877: WHERE AID.accounting_event_id IS NULL
3878: AND AID.invoice_id IN
3879: ( SELECT AI.invoice_id
3880: FROM ap_invoice_payments_all AIP,
3881: ap_invoices_all AI
3882: WHERE AIP.invoice_id = AI.invoice_id
3883: AND AIP.accounting_event_id = l_accounting_event_ids(i)
3884: AND AIP.check_id = l_check_ids(i)

Line 5788: FROM ap_invoice_payments_all AIP

5784: APH.check_id check_id,
5785: APH.org_id,
5786: AC.legal_entity_id,
5787: ( SELECT AIP.set_of_books_id
5788: FROM ap_invoice_payments_all AIP
5789: WHERE AIP.check_id = APH.check_id
5790: AND ROWNUM = 1
5791: ) ledger_id
5792: FROM

Line 5827: FROM ap_invoice_payments_all AIP

5823: APH.check_id check_id,
5824: APH.org_id,
5825: AC.legal_entity_id,
5826: ( SELECT AIP.set_of_books_id
5827: FROM ap_invoice_payments_all AIP
5828: WHERE AIP.check_id = APH.check_id
5829: AND ROWNUM = 1
5830: ) ledger_id
5831: FROM

Line 6238: FROM ap_invoice_payments_all AIP

6234: APH.check_id,
6235: APH.org_id,
6236: AC.legal_entity_id,
6237: ( SELECT AIP.set_of_books_id
6238: FROM ap_invoice_payments_all AIP
6239: WHERE AIP.check_id = APH.check_id
6240: AND ROWNUM = 1
6241: ) ledger_id
6242: FROM ap_payment_history_all APH,

Line 6257: FROM ap_invoice_payments_all AIP

6253: APH.check_id,
6254: APH.org_id,
6255: AC.legal_entity_id,
6256: ( SELECT AIP.set_of_books_id
6257: FROM ap_invoice_payments_all AIP
6258: WHERE AIP.check_id = APH.check_id
6259: AND ROWNUM = 1
6260: ) ledger_id
6261: FROM ap_payment_history_all APH,