APPS.AP_PURGE_PKG dependencies on AP_HISTORY_INVOICES

Line 2114: from ap_history_invoices

2110: select 'Y'
2111: into range_inserted
2112: from sys.dual
2113: where exists (select null
2114: from ap_history_invoices
2115: where purge_name = p_purge_name
2116: and invoice_id between range_low and range_high);
2117:
2118: EXCEPTION

Line 2131: INSERT INTO ap_history_invoices_all

2127: Print('(Invoice_Summary)'||debug_info);
2128: END IF;
2129: -- summarize_invoices
2130: -- bug5487843, added org_id and changed to _ALL
2131: INSERT INTO ap_history_invoices_all
2132: (invoice_id, vendor_id, vendor_site_code, invoice_num, invoice_date,
2133: invoice_amount, batch_name, purge_name, doc_sequence_id,
2134: doc_sequence_value,org_id)
2135: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,

Line 6703: delete from ap_history_invoices

6699: FUNCTION clear_invoice_history RETURN BOOLEAN IS
6700:
6701: BEGIN
6702:
6703: delete from ap_history_invoices
6704: where purge_name = g_purge_name;
6705:
6706: RETURN (TRUE);
6707:

Line 6746: from ap_history_invoices ahi

6742: BEGIN
6743:
6744: delete from ap_history_invoice_payments ahp
6745: where not exists (select null
6746: from ap_history_invoices ahi
6747: where ahi.invoice_id = ahp.invoice_id);
6748:
6749: RETURN (TRUE);
6750: