APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_RECAPP_INSERT_GT

Line 4482: g_state := 'Populating FII_AR_RECAPP_INSERT_GT';

4478: FII_UTIL.print_timer('Duration');
4479: FII_UTIL.put_line('');
4480: end if;
4481:
4482: g_state := 'Populating FII_AR_RECAPP_INSERT_GT';
4483: if g_debug_flag = 'Y' then
4484: FII_UTIL.put_line(g_state);
4485: FII_UTIL.start_timer;
4486: FII_UTIL.put_line('');

Line 4490: insert into FII_AR_RECAPP_INSERT_GT

4486: FII_UTIL.put_line('');
4487: end if;
4488:
4489: -- PaySch Update 3
4490: insert into FII_AR_RECAPP_INSERT_GT
4491: (
4492: applied_payment_schedule_id,
4493: payment_schedule_id,
4494: applied_customer_trx_id,

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

4572: and application_type = 'CM')
4573: ;
4574:
4575: if g_debug_flag = 'Y' then
4576: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_RECAPP_INSERT_GT');
4577: FII_UTIL.stop_timer;
4578: FII_UTIL.print_timer('Duration');
4579: FII_UTIL.put_line('');
4580: end if;

Line 4721: from FII_AR_RECAPP_INSERT_GT

4717: from FII_AR_ADJ_UPDATE_GT
4718: union all
4719: -- PaySch Update 3
4720: select APPLIED_PAYMENT_SCHEDULE_ID
4721: from FII_AR_RECAPP_INSERT_GT
4722: union all
4723: -- PaySch Update 3 (receipt rates)
4724: select PAYMENT_SCHEDULE_ID
4725: from FII_AR_RECAPP_INSERT_GT

Line 4725: from FII_AR_RECAPP_INSERT_GT

4721: from FII_AR_RECAPP_INSERT_GT
4722: union all
4723: -- PaySch Update 3 (receipt rates)
4724: select PAYMENT_SCHEDULE_ID
4725: from FII_AR_RECAPP_INSERT_GT
4726: )
4727: and CLASS IN ('INV', 'DM', 'CB', 'CM', 'DEP', 'BR', 'PMT');
4728: --and decode(g_collection_criteria, 'GL', gl_date, trx_date) >= g_global_start_date;
4729:

Line 6287: from FII_AR_RECAPP_INSERT_GT) app,

6283: PAYMENT_SCHEDULE_ID,
6284: created_by,
6285: creation_date,
6286: org_id
6287: from FII_AR_RECAPP_INSERT_GT) app,
6288: FII_AR_PMT_SCHEDULES_F rctsch, --> FII_AR_PAYSCH_MERGE_GT
6289: -- previous_customer_trx_id needs
6290: -- a join to AR_PAYMENT_SCHEDULES_ALL
6291: (select rct.cash_receipt_id,

Line 8740: from FII_AR_RECAPP_INSERT_GT

8736: --Case 3
8737: select null payment_schedule_id, customer_trx_id, min(min_date) min_date
8738: from
8739: (select applied_customer_trx_id customer_trx_id, min(decode(g_collection_criteria, 'GL', gl_date, apply_date)) min_date
8740: from FII_AR_RECAPP_INSERT_GT
8741: where applied_payment_schedule_id > 0
8742: group by applied_customer_trx_id
8743:
8744: union all