APPS.IEX_STRY_CUWF_PUB dependencies on IEX_DELINQUENCIES

Line 154: from iex_delinquencies_all b, hz_parties a,iex_strategies c

150: select a.party_id, a.party_type, a.party_name,
151: b.cust_account_id,
152: b.status, b.payment_schedule_id,
153: b.aging_bucket_line_id,c.delinquency_id
154: from iex_delinquencies_all b, hz_parties a,iex_strategies c
155: where a.party_id(+) = b.party_cust_id
156: and c.strategy_id = p_strategy_id
157: and c.delinquency_id = b.delinquency_id;
158:

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: