APPS.IEX_SCORE_CASE_PVT dependencies on IEX_PROMISE_DETAILS
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';