DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_TRIAL_BALANCE

Line 5627: debug_info := 'ap_trial_balance';

5623: WHERE PL.double_check_flag = 'Y'
5624: AND -- Bug 8913560 PL.invoice_id BETWEEN range_low AND range_high
5625: PL.rowid BETWEEN p_start_rowid AND p_end_rowid );
5626:
5627: debug_info := 'ap_trial_balance';
5628: IF g_debug_switch in ('y','Y') THEN
5629: Print('(Delete_AP_Tables)'||debug_info);
5630: END IF;
5631:

Line 5635: DELETE FROM ap_trial_balance

5631:
5632:
5633: -- delete_trial_balance
5634:
5635: DELETE FROM ap_trial_balance
5636: WHERE invoice_id IN (
5637: SELECT PL.invoice_id
5638: FROM ap_purge_invoice_list PL
5639: WHERE PL.double_check_flag = 'Y'