APPS.AP_PURGE_PKG dependencies on AP_BATCHES

Line 2393: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b

2389: doc_sequence_value,org_id)
2390: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,
2391: i.invoice_date, i.invoice_amount, b.batch_name, p_purge_name,
2392: i.doc_sequence_id, i.doc_sequence_value,i.org_id
2393: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b
2394: WHERE i.vendor_site_id = v.vendor_site_id
2395: AND i.batch_id = b.batch_id (+)
2396: AND i.invoice_id IN (SELECT PL.invoice_id
2397: FROM ap_purge_invoice_list PL

Line 5798: debug_info := 'deleting from ap_batches';

5794:
5795: END LOOP; */
5796:
5797: /* 9481539, moving this delete statement to parent process delete_seeded_data
5798: debug_info := 'deleting from ap_batches';
5799: IF g_debug_switch in ('y','Y') THEN
5800: Print('(Delete_AP_Tables)'||debug_info);
5801: END IF;
5802:

Line 5806: DELETE FROM ap_batches B

5802:
5803:
5804: -- delete_batches
5805:
5806: DELETE FROM ap_batches B
5807: WHERE B.last_update_date <= g_activity_date
5808: AND NOT EXISTS (
5809: SELECT null
5810: FROM ap_invoices I

Line 7240: DELETE FROM ap_batches B

7236: accounting_event_rows:= 0;
7237:
7238: -- delete_batches
7239: --9481539
7240: DELETE FROM ap_batches B
7241: WHERE B.last_update_date <= g_activity_date
7242: AND NOT EXISTS (
7243: SELECT null
7244: FROM ap_invoices_all I --bug13799066