DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_HOLDS

Line 5128: debug_info := 'ap_holds';

5124: FROM ap_purge_invoice_list PL
5125: WHERE PL.double_check_flag = 'Y'
5126: AND PL.invoice_id BETWEEN range_low AND range_high);
5127:
5128: debug_info := 'ap_holds';
5129: IF g_debug_switch in ('y','Y') THEN
5130: Print('(Delete_AP_Tables)'||debug_info);
5131: END IF;
5132:

Line 5136: DELETE FROM ap_holds

5132:
5133:
5134: -- delete_holds
5135:
5136: DELETE FROM ap_holds
5137: WHERE invoice_id IN (
5138: SELECT PL.invoice_id
5139: FROM ap_purge_invoice_list PL
5140: WHERE PL.double_check_flag = 'Y'