APPS.IEX_SCORE_CASE_PVT dependencies on IEX_DELINQUENCIES

Line 313: from iex_promise_details A, iex_delinquencies B

309: END IF;
310: BEGIN
311: select count(1)
312: into l_NumPromiseBroken
313: from iex_promise_details A, iex_delinquencies B
314: where A.DELINQUENCY_ID = B.DELINQUENCY_ID
315: and B.CASE_ID = p_case_id
316: and A.STATE = 'BROKEN_PROMISE'
317: and A.STATUS <> 'PENDING';

Line 361: from iex_delinquencies

357: -- begin raverma 04172003 append cust_account_id to WHERE clause
358: BEGIN
359: select count(1)
360: into l_NumDelinquencies
361: from iex_delinquencies
362: where creation_date = sysdate - (s_nConsiderPastXMonths * 30)
363: and cust_account_id = l_CustAccountID
364: and status <> 'PREDELINQUENT';
365: EXCEPTION