APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_TRANS_DELETE_GT

Line 4582: g_state := 'Populating FII_AR_TRANS_DELETE_GT';

4578: FII_UTIL.print_timer('Duration');
4579: FII_UTIL.put_line('');
4580: end if;
4581:
4582: g_state := 'Populating FII_AR_TRANS_DELETE_GT';
4583: if g_debug_flag = 'Y' then
4584: FII_UTIL.put_line(g_state);
4585: FII_UTIL.start_timer;
4586: FII_UTIL.put_line('');

Line 4590: insert into FII_AR_TRANS_DELETE_GT

4586: FII_UTIL.put_line('');
4587: end if;
4588:
4589: -- PaySch Delete 1
4590: insert into FII_AR_TRANS_DELETE_GT
4591: (
4592: customer_trx_id
4593: )
4594: select CUSTOMER_TRX_ID

Line 4602: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_TRANS_DELETE_GT');

4598: and last_update_date <= g_sysdate_time
4599: ;
4600:
4601: if g_debug_flag = 'Y' then
4602: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_TRANS_DELETE_GT');
4603: FII_UTIL.stop_timer;
4604: FII_UTIL.print_timer('Duration');
4605: FII_UTIL.put_line('');
4606: end if;

Line 4753: from FII_AR_TRANS_DELETE_GT

4749: from fii_ar_pmt_schedules_f
4750: where CUSTOMER_TRX_ID in (
4751: -- PaySch Delete 1
4752: select CUSTOMER_TRX_ID
4753: from FII_AR_TRANS_DELETE_GT
4754: union all
4755: -- PaySch Delete 2
4756: select CUSTOMER_TRX_ID
4757: from FII_AR_PAYSCH_INSERT_GT -- FII_AR_PAYSCH_DELETE_PAYSCH_GT

Line 5502: from FII_AR_TRANS_DELETE_GT

5498: delete from fii_ar_transactions_f
5499: where CUSTOMER_TRX_ID in (
5500: -- Trans Delete
5501: select CUSTOMER_TRX_ID
5502: from FII_AR_TRANS_DELETE_GT
5503: );
5504:
5505: if g_debug_flag = 'Y' then
5506: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_TRANSACTIONS_F');