APPS.AP_PURGE_PKG dependencies on AP_HISTORY_CHECKS_ALL

Line 2156: INSERT INTO ap_history_checks_all

2152:
2153: --5007666, added payment_id
2154: -- bug5487843, added org_id and changed to _ALL
2155: -- summarize_checks
2156: INSERT INTO ap_history_checks_all
2157: (check_id, bank_account_id, check_number, check_date, amount,
2158: currency_code, void_flag, purge_name, doc_sequence_id,
2159: doc_sequence_value, payment_id,org_id)
2160: SELECT

Line 2173: FROM ap_history_checks_all hc

2169: AND IP.check_id = AC.check_id
2170: AND PL.double_check_flag = 'Y'
2171: AND PL.invoice_id BETWEEN range_low AND range_high
2172: AND NOT EXISTS (SELECT null
2173: FROM ap_history_checks_all hc
2174: WHERE hc.check_id = AC.check_id)
2175: GROUP BY ac.check_id, ac.bank_account_id, ac.check_number,
2176: ac.check_date, ac.amount, ac.currency_code,
2177: DECODE(void_date, null, null, 'Y'), purge_name,