APPS.AP_PURGE_PKG dependencies on AP_HISTORY_CHECKS

Line 2411: INSERT INTO ap_history_checks_all

2407:
2408: --5007666, added payment_id
2409: -- bug5487843, added org_id and changed to _ALL
2410: -- summarize_checks
2411: INSERT INTO ap_history_checks_all
2412: (check_id, bank_account_id, check_number, check_date, amount,
2413: currency_code, void_flag, purge_name, doc_sequence_id,
2414: doc_sequence_value, payment_id,org_id)
2415: SELECT

Line 2428: FROM ap_history_checks_all hc

2424: AND IP.check_id = AC.check_id
2425: AND PL.double_check_flag = 'Y'
2426: AND PL.invoice_id BETWEEN range_low AND range_high
2427: AND NOT EXISTS (SELECT null
2428: FROM ap_history_checks_all hc
2429: WHERE hc.check_id = AC.check_id)
2430: GROUP BY ac.check_id, ac.bank_account_id, ac.check_number,
2431: ac.check_date, ac.amount, ac.currency_code,
2432: DECODE(void_date, null, null, 'Y'), purge_name,

Line 7307: delete from ap_history_checks

7303: FUNCTION clear_check_history RETURN BOOLEAN IS
7304:
7305: BEGIN
7306:
7307: delete from ap_history_checks
7308: where purge_name = g_purge_name;
7309:
7310: RETURN (TRUE);
7311: