DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 270: IEX_DELINQUENCIES_ALL del

266: CURSOR del_crs(p_promise_id number) IS
267: SELECT del.party_cust_id,del.cust_account_id,del.CUSTOMER_SITE_USE_ID,
268: del.delinquency_id, prd.CNSLD_INVOICE_ID, prd.CONTRACT_ID
269: FROM IEX_PROMISE_DETAILS prd,
270: IEX_DELINQUENCIES_ALL del
271: WHERE prd.PROMISE_DETAIL_ID = P_PROMISE_ID
272: and prd.delinquency_id = del.delinquency_id;
273: --end bug#2369298 schekuri 24-Feb-2006
274: begin

Line 1083: from iex_delinquencies_all

1079: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
1080: --Begin bug 7237026 17-Nov-2208 barathsr
1081: CURSOR c_org_id (p_del_id number) IS
1082: select org_id
1083: from iex_delinquencies_all
1084: where delinquency_id = p_del_id;
1085: --End bug 7237026 17-Nov-2208 barathsr
1086:
1087: BEGIN

Line 2400: from iex_delinquencies_all

2396:
2397: --Begin bug 7237026 17-Nov-2008 barathsr
2398: CURSOR c_org_id (p_del_id number) IS
2399: select org_id
2400: from iex_delinquencies_all
2401: where delinquency_id = p_del_id;
2402: --End bug 7237026 17-Nov-2008 barathsr
2403:
2404: