APPS.AP_PURGE_PKG dependencies on AP_BATCHES

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

2134: doc_sequence_value,org_id)
2135: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,
2136: i.invoice_date, i.invoice_amount, b.batch_name, p_purge_name,
2137: i.doc_sequence_id, i.doc_sequence_value,i.org_id
2138: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b
2139: WHERE i.vendor_site_id = v.vendor_site_id
2140: AND i.batch_id = b.batch_id (+)
2141: AND i.invoice_id IN (SELECT PL.invoice_id
2142: FROM ap_purge_invoice_list PL

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

5241: end if;
5242:
5243: END LOOP;
5244:
5245: debug_info := 'deleting from ap_batches';
5246: IF g_debug_switch in ('y','Y') THEN
5247: Print('(Delete_AP_Tables)'||debug_info);
5248: END IF;
5249:

Line 5253: DELETE FROM ap_batches B

5249:
5250:
5251: -- delete_batches
5252:
5253: DELETE FROM ap_batches B
5254: WHERE B.last_update_date <= g_activity_date
5255: AND NOT EXISTS (
5256: SELECT null
5257: FROM ap_invoices I