DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_INV_APRVL_HIST

Line 5143: debug_info := 'ap_inv_aprvl_hist';

5139: FROM ap_purge_invoice_list PL
5140: WHERE PL.double_check_flag = 'Y'
5141: AND PL.invoice_id BETWEEN range_low AND range_high);
5142:
5143: debug_info := 'ap_inv_aprvl_hist';
5144: IF g_debug_switch in ('y','Y') THEN
5145: Print('(Delete_AP_Tables)'||debug_info);
5146: END IF;
5147:

Line 5151: DELETE FROM ap_inv_aprvl_hist

5147:
5148:
5149: -- delete approval history
5150:
5151: DELETE FROM ap_inv_aprvl_hist
5152: WHERE invoice_id IN (
5153: SELECT PL.invoice_id
5154: FROM ap_purge_invoice_list PL
5155: WHERE PL.double_check_flag = 'Y'