eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_STRY_CUWF_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 160: --Removed the outer join to ar_payment_schedules to avoid FTS & NMV.

156: and c.strategy_id = p_strategy_id
157: and c.delinquency_id = b.delinquency_id;
158:
159: --Begin bug#4930374 schekuri 12-Jan-2006
160: --Removed the outer join to ar_payment_schedules to avoid FTS & NMV.
161: cursor c_get_payment(p_delinquency_id number) is
162: select a.amount_due_remaining
163: from ar_payment_schedules a, iex_delinquencies b
164: where a.payment_schedule_id = b.payment_schedule_id

Line 163: from ar_payment_schedules a, iex_delinquencies b

159: --Begin bug#4930374 schekuri 12-Jan-2006
160: --Removed the outer join to ar_payment_schedules to avoid FTS & NMV.
161: cursor c_get_payment(p_delinquency_id number) is
162: select a.amount_due_remaining
163: from ar_payment_schedules a, iex_delinquencies b
164: where a.payment_schedule_id = b.payment_schedule_id
165: and b.delinquency_id = p_delinquency_id;
166:
167: /*cursor c_get_payment(p_delinquency_id number) is

Line 169: from ar_payment_schedules a, iex_delinquencies b

165: and b.delinquency_id = p_delinquency_id;
166:
167: /*cursor c_get_payment(p_delinquency_id number) is
168: select a.amount_due_remaining
169: from ar_payment_schedules a, iex_delinquencies b
170: where a.payment_schedule_id(+) = b.payment_schedule_id
171: and b.delinquency_id = p_delinquency_id;*/
172: --End bug#4930374 schekuri 12-Jan-2006
173: