DBA Data[Home] [Help]

APPS.IEX_DUNNING_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 2570: ar_payment_schedules_all ar

2566: cursor c_staged_dunning_level is
2567: select ar.staged_dunning_level,
2568: ar.payment_schedule_id
2569: from iex_delinquencies_all iex,
2570: ar_payment_schedules_all ar
2571: where iex.payment_schedule_id = ar.payment_schedule_id
2572: and ar.staged_dunning_level is not null
2573: and iex.staged_dunning_level is null
2574: and iex.status in ('DELINQUENT','PREDELINQUENT')

Line 2801: --Copy the Staged level of an Invoice from AR_PAYMENT_SCHEDULES_ALL table to IEX_DELINQUENCIES_ALL table.

2797: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2798:
2799: l_staged_dunning_level.delete;
2800: l_payment_schedule_id.delete;
2801: --Copy the Staged level of an Invoice from AR_PAYMENT_SCHEDULES_ALL table to IEX_DELINQUENCIES_ALL table.
2802: --It will update only the records that have staged_dunning_level as NULL
2803: BEGIN
2804: OPEN c_staged_dunning_level;
2805: LOOP