APPS.IEX_PROMISES_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 269: IEX_DELINQUENCIES_ALL del

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

Line 1098: from iex_delinquencies_all

1094: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
1095: --Begin bug 7237026 17-Nov-2208 barathsr
1096: CURSOR c_org_id (p_del_id number) IS
1097: select org_id
1098: from iex_delinquencies_all
1099: where delinquency_id = p_del_id;
1100: --End bug 7237026 17-Nov-2208 barathsr
1101:
1102: BEGIN

Line 2501: from iex_delinquencies_all

2497:
2498: --Begin bug 7237026 17-Nov-2008 barathsr
2499: CURSOR c_org_id (p_del_id number) IS
2500: select org_id
2501: from iex_delinquencies_all
2502: where delinquency_id = p_del_id;
2503: --End bug 7237026 17-Nov-2008 barathsr
2504:
2505:

Line 3042: update iex_delinquencies_all

3038: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3039: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'l_amt_due_remaining: ' || l_amt_due_remaining);
3040: end if;
3041: if l_amt_due_remaining <= l_total_already_pro_amt and nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then --modified for bug 14318148
3042: update iex_delinquencies_all
3043: set staged_dunning_level = 0
3044: where delinquency_id = l_promised_delinquency_id;
3045:
3046: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3052: update iex_delinquencies_all

3048: end if;
3049: else
3050: iex_utilities.MaxStageForanDelinquency (p_delinquency_id => l_promised_delinquency_id
3051: , p_stage_number => l_stage_number);
3052: update iex_delinquencies_all
3053: set staged_dunning_level = l_stage_number
3054: where delinquency_id = l_promised_delinquency_id
3055: and staged_dunning_level=0; --added for bug 14318148
3056: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN