APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_PAYSCH_DELETE_GT

Line 4737: g_state := 'Populating FII_AR_PAYSCH_DELETE_GT';

4733: FII_UTIL.print_timer('Duration');
4734: FII_UTIL.put_line('');
4735: end if;
4736:
4737: g_state := 'Populating FII_AR_PAYSCH_DELETE_GT';
4738: if g_debug_flag = 'Y' then
4739: FII_UTIL.put_line(g_state);
4740: FII_UTIL.start_timer;
4741: FII_UTIL.put_line('');

Line 4744: insert into FII_AR_PAYSCH_DELETE_GT

4740: FII_UTIL.start_timer;
4741: FII_UTIL.put_line('');
4742: end if;
4743:
4744: insert into FII_AR_PAYSCH_DELETE_GT
4745: (
4746: payment_schedule_id
4747: )
4748: select PAYMENT_SCHEDULE_ID

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

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');
4767: FII_UTIL.stop_timer;
4768: FII_UTIL.print_timer('Duration');
4769: FII_UTIL.put_line('');
4770: end if;

Line 4905: from FII_AR_PAYSCH_DELETE_GT

4901: delete from fii_ar_pmt_schedules_f
4902: where PAYMENT_SCHEDULE_ID in (
4903: -- PaySch Delete 1 2 3
4904: select PAYMENT_SCHEDULE_ID
4905: from FII_AR_PAYSCH_DELETE_GT
4906: );
4907:
4908: if g_debug_flag = 'Y' then
4909: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_PMT_SCHEDULES_F');

Line 5300: from FII_AR_PAYSCH_DELETE_GT

5296: delete from fii_ar_dispute_history_f
5297: where PAYMENT_SCHEDULE_ID in (
5298: -- PaySch Delete 1 2 3
5299: select PAYMENT_SCHEDULE_ID
5300: from FII_AR_PAYSCH_DELETE_GT
5301: );
5302:
5303: if g_debug_flag = 'Y' then
5304: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_DISPUTE_HISTORY_F');

Line 8732: from fii_ar_paysch_delete_gt

8728: SELECT payment_schedule_id, customer_trx_id, min_date
8729: BULK COLLECT INTO sch_id_array, trx_id_array, min_date_array
8730: FROM (--Case 1 and Case 2
8731: select payment_schedule_id, null customer_trx_id, null min_date
8732: from fii_ar_paysch_delete_gt
8733:
8734: union all
8735:
8736: --Case 3

Line 8901: from fii_ar_paysch_delete_gt

8897: SELECT payment_schedule_id, customer_trx_id, min_date
8898: BULK COLLECT INTO sch_id_array, trx_id_array, min_date_array
8899: FROM (--Case 1 and 2
8900: select payment_schedule_id, null customer_trx_id, to_date(1, 'J') min_date
8901: from fii_ar_paysch_delete_gt
8902:
8903: union all
8904:
8905: --Case 3