APPS.AP_PURGE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 802: -- Perf bug 5052674 -- go to base table AP_INVOICE_PAYMENTS_ALL for

798: Print('(Do_independent_inv_checks)' ||debug_info);
799: END IF;
800:
801: -- Test Payments
802: -- Perf bug 5052674 -- go to base table AP_INVOICE_PAYMENTS_ALL for
803: -- main SELECT query and base table CE_STATEMENT_RECONCILS_ALL for sub-query
804: DELETE
805: FROM ap_purge_invoice_list PL
806: WHERE EXISTS

Line 808: FROM ap_invoice_payments_all P,

804: DELETE
805: FROM ap_purge_invoice_list PL
806: WHERE EXISTS
807: (SELECT 'payment not purgeable'
808: FROM ap_invoice_payments_all P,
809: ap_checks C
810: WHERE P.invoice_id = PL.invoice_id
811: AND P.check_id = C.check_id
812: AND (((P.posted_flag <> 'Y'

Line 2166: ap_invoice_payments_all IP,

2162: ac.amount, ac.currency_code, DECODE(void_date, null, null, 'Y'),
2163: p_purge_name, ac.doc_sequence_id, ac.doc_sequence_value, ac.payment_id,
2164: ac.org_id
2165: FROM ap_checks_all AC,
2166: ap_invoice_payments_all IP,
2167: ap_purge_invoice_list PL
2168: WHERE PL.invoice_id = IP.invoice_id
2169: AND IP.check_id = AC.check_id
2170: AND PL.double_check_flag = 'Y'

Line 2193: FROM ap_invoice_payments_all IP, ap_purge_invoice_list PL

2189: INSERT INTO ap_history_inv_payments_all
2190: (invoice_id, check_id, amount,org_id)
2191: SELECT
2192: IP.invoice_id, IP.check_id, SUM(IP.amount),IP.org_id
2193: FROM ap_invoice_payments_all IP, ap_purge_invoice_list PL
2194: WHERE IP.invoice_id = PL.invoice_id
2195: AND PL.double_check_flag = 'Y'
2196: AND PL.invoice_id BETWEEN range_low AND range_high
2197: GROUP BY IP.invoice_id, IP.check_id,