DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 999: from ar_payment_schedules_all a, iex_delinquencies_all b

995:
996: -- bug 4930376 ctlee sql id 14771930, use _all performance
997: cursor c_get_payment(p_delinquency_id number) is
998: select a.amount_due_remaining
999: from ar_payment_schedules_all a, iex_delinquencies_all b
1000: where a.payment_schedule_id(+) = b.payment_schedule_id
1001: and b.delinquency_id = p_delinquency_id;
1002:
1003: cursor c_get_witem_temp(p_work_item_id NUMBER) is

Line 1862: from ar_payment_schedules_all a, iex_delinquencies_all b

1858:
1859: -- bug 4930376 ctlee sql id 14772154, use _all performance
1860: cursor c_get_payment(p_delinquency_id number) is
1861: select a.amount_due_remaining
1862: from ar_payment_schedules_all a, iex_delinquencies_all b
1863: where a.payment_schedule_id(+) = b.payment_schedule_id
1864: and b.delinquency_id = p_delinquency_id;
1865:
1866: cursor c_get_witem_temp(p_work_item_id NUMBER) is