DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on AP_LIABILITY_BALANCE

Line 5348: -- Added logic to purge the ap_liability_balance

5344: END IF;
5345:
5346: -- Bug 2463233
5347: -- Code Added by MSWAMINA
5348: -- Added logic to purge the ap_liability_balance
5349: --
5350: debug_info := 'ap_liability_balance';
5351: IF g_debug_switch in ('y','Y') THEN
5352: Print('(Purge_Accounting)'||debug_info);

Line 5350: debug_info := 'ap_liability_balance';

5346: -- Bug 2463233
5347: -- Code Added by MSWAMINA
5348: -- Added logic to purge the ap_liability_balance
5349: --
5350: debug_info := 'ap_liability_balance';
5351: IF g_debug_switch in ('y','Y') THEN
5352: Print('(Purge_Accounting)'||debug_info);
5353: END IF;
5354:

Line 5355: DELETE FROM ap_liability_balance alb

5351: IF g_debug_switch in ('y','Y') THEN
5352: Print('(Purge_Accounting)'||debug_info);
5353: END IF;
5354:
5355: DELETE FROM ap_liability_balance alb
5356: WHERE EXISTS (
5357: SELECT 'records exist'
5358: FROM ap_purge_invoice_list pil
5359: WHERE alb.invoice_id = pil.invoice_id