APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_RECAPP_DELETE_GT

Line 4616: g_state := 'Populating FII_AR_RECAPP_DELETE_GT';

4612: from ar_payment_schedules_all
4613: where PAYMENT_SCHEDULE_ID > G_MAX_PAYMENT_SCHEDULE_ID;
4614: */
4615:
4616: g_state := 'Populating FII_AR_RECAPP_DELETE_GT';
4617: if g_debug_flag = 'Y' then
4618: FII_UTIL.put_line(g_state);
4619: FII_UTIL.start_timer;
4620: FII_UTIL.put_line('');

Line 4624: insert into FII_AR_RECAPP_DELETE_GT

4620: FII_UTIL.put_line('');
4621: end if;
4622:
4623: -- PaySch Delete 3
4624: insert into FII_AR_RECAPP_DELETE_GT
4625: (
4626: receivable_application_id,
4627: payment_schedule_id,
4628: CASH_RECEIPT_ID

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

4635: )
4636: ;
4637:
4638: if g_debug_flag = 'Y' then
4639: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_RECAPP_DELETE_GT');
4640: FII_UTIL.stop_timer;
4641: FII_UTIL.print_timer('Duration');
4642: FII_UTIL.put_line('');
4643: end if;

Line 4762: from FII_AR_RECAPP_DELETE_GT

4758: )
4759: union
4760: -- PaySch Delete 3
4761: select PAYMENT_SCHEDULE_ID
4762: from FII_AR_RECAPP_DELETE_GT
4763: ;
4764:
4765: if g_debug_flag = 'Y' then
4766: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_PAYSCH_DELETE_GT');

Line 6410: from FII_AR_RECAPP_DELETE_GT

6406: else null end
6407: else trxsch_payment_schedule_id end) is null
6408: union all
6409: select RECEIVABLE_APPLICATION_ID
6410: from FII_AR_RECAPP_DELETE_GT
6411: );
6412:
6413: if g_debug_flag = 'Y' then
6414: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_RECEIPTS_F');

Line 8817: from FII_AR_RECAPP_DELETE_GT

8813: SELECT cash_receipt_id, actual_date_closed
8814: BULK COLLECT INTO rct_id_array, date_closed_array
8815: FROM (--Case 1
8816: select cash_receipt_id, 1 actual_date_closed
8817: from FII_AR_RECAPP_DELETE_GT
8818:
8819: union all
8820:
8821: --Cases 2