APPS.AP_PURGE_PKG dependencies on AP_HISTORY_INVOICES

Line 2369: from ap_history_invoices

2365: select 'Y'
2366: into range_inserted
2367: from sys.dual
2368: where exists (select null
2369: from ap_history_invoices
2370: where purge_name = p_purge_name
2371: and invoice_id between range_low and range_high);
2372:
2373: EXCEPTION

Line 2386: INSERT INTO ap_history_invoices_all

2382: Print('(Invoice_Summary)'||debug_info);
2383: END IF;
2384: -- summarize_invoices
2385: -- bug5487843, added org_id and changed to _ALL
2386: INSERT INTO ap_history_invoices_all
2387: (invoice_id, vendor_id, vendor_site_code, invoice_num, invoice_date,
2388: invoice_amount, batch_name, purge_name, doc_sequence_id,
2389: doc_sequence_value,org_id)
2390: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,

Line 7410: delete from ap_history_invoices

7406: FUNCTION clear_invoice_history RETURN BOOLEAN IS
7407:
7408: BEGIN
7409:
7410: delete from ap_history_invoices
7411: where purge_name = g_purge_name;
7412:
7413: RETURN (TRUE);
7414:

Line 7453: from ap_history_invoices ahi

7449: BEGIN
7450:
7451: delete from ap_history_invoice_payments ahp
7452: where not exists (select null
7453: from ap_history_invoices ahi
7454: where ahi.invoice_id = ahp.invoice_id);
7455:
7456: RETURN (TRUE);
7457: