DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_PUB dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 772: from ar_payment_schedules_all a, iex_delinquencies b

768:
769: -- bug 4930376 ctlee sql id 14771930, use _all performance
770: cursor c_get_payment(p_delinquency_id number) is
771: select a.amount_due_remaining
772: from ar_payment_schedules_all a, iex_delinquencies b
773: where a.payment_schedule_id(+) = b.payment_schedule_id
774: and b.delinquency_id = p_delinquency_id;
775:
776: cursor c_get_witem_temp(p_work_item_id NUMBER) is

Line 1614: from ar_payment_schedules_all a, iex_delinquencies b

1610:
1611: -- bug 4930376 ctlee sql id 14772154, use _all performance
1612: cursor c_get_payment(p_delinquency_id number) is
1613: select a.amount_due_remaining
1614: from ar_payment_schedules_all a, iex_delinquencies b
1615: where a.payment_schedule_id(+) = b.payment_schedule_id
1616: and b.delinquency_id = p_delinquency_id;
1617:
1618: cursor c_get_witem_temp(p_work_item_id NUMBER) is