APPS.AP_PURGE_PKG dependencies on AP_DOC_SEQUENCE_AUDIT

Line 4989: Print('ap_doc_sequence_audit, Checks');

4985:
4986: debug_info := 'Deleting one subgroup of Invoices';
4987: IF g_debug_switch in ('y','Y') THEN
4988: Print('(Delete_AP_Tables)'||debug_info);
4989: Print('ap_doc_sequence_audit, Checks');
4990: END IF;
4991:
4992: /* Bug 5052709 - removal of obsolete SQL
4993: -- Move the deletion of ap_chrg_allocations from purge_pos to here.

Line 5011: DELETE FROM ap_doc_sequence_audit AUD

5007: */
5008: -- delete_check_sequence_audit
5009:
5010: /* bug3068811 : Changed from EXISTS to IN for performance */
5011: DELETE FROM ap_doc_sequence_audit AUD
5012: WHERE (AUD.doc_sequence_id , AUD.doc_sequence_value)
5013: IN (SELECT C.doc_sequence_id , C.doc_sequence_value
5014: FROM ap_purge_invoice_list PL,
5015: ap_checks C,

Line 5172: debug_info := 'ap_doc_sequence_audit, Invoices';

5168: FROM ap_purge_invoice_list PL
5169: WHERE PL.double_check_flag = 'Y'
5170: AND PL.invoice_id BETWEEN range_low AND range_high);
5171:
5172: debug_info := 'ap_doc_sequence_audit, Invoices';
5173: IF g_debug_switch in ('y','Y') THEN
5174: Print('(Delete_AP_Tables)'||debug_info);
5175: END IF;
5176:

Line 5180: DELETE FROM ap_doc_sequence_audit AUD

5176:
5177: -- delete_inv_seq_audit
5178:
5179: /* bug3284915 : Changed from EXISTS to IN for performance */
5180: DELETE FROM ap_doc_sequence_audit AUD
5181: WHERE (AUD.doc_sequence_id , AUD.doc_sequence_value)
5182: IN (SELECT I.doc_sequence_id , I.doc_sequence_value
5183: FROM ap_purge_invoice_list PL,
5184: ap_invoices I