DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_INV_APRVL_HIST

Line 5659: debug_info := 'ap_inv_aprvl_hist';

5655: WHERE PL.double_check_flag = 'Y'
5656: AND -- Bug 8913560 PL.invoice_id BETWEEN range_low AND range_high
5657: PL.rowid BETWEEN p_start_rowid AND p_end_rowid );
5658:
5659: debug_info := 'ap_inv_aprvl_hist';
5660: IF g_debug_switch in ('y','Y') THEN
5661: Print('(Delete_AP_Tables)'||debug_info);
5662: END IF;
5663:

Line 5667: DELETE FROM ap_inv_aprvl_hist

5663:
5664:
5665: -- delete approval history
5666:
5667: DELETE FROM ap_inv_aprvl_hist
5668: WHERE invoice_id IN (
5669: SELECT PL.invoice_id
5670: FROM ap_purge_invoice_list PL
5671: WHERE PL.double_check_flag = 'Y'