DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_HOLDS

Line 5643: debug_info := 'ap_holds';

5639: WHERE PL.double_check_flag = 'Y'
5640: AND -- Bug 8913560 PL.invoice_id BETWEEN range_low AND range_high
5641: PL.rowid BETWEEN p_start_rowid AND p_end_rowid );
5642:
5643: debug_info := 'ap_holds';
5644: IF g_debug_switch in ('y','Y') THEN
5645: Print('(Delete_AP_Tables)'||debug_info);
5646: END IF;
5647:

Line 5651: DELETE FROM ap_holds

5647:
5648:
5649: -- delete_holds
5650:
5651: DELETE FROM ap_holds
5652: WHERE invoice_id IN (
5653: SELECT PL.invoice_id
5654: FROM ap_purge_invoice_list PL
5655: WHERE PL.double_check_flag = 'Y'