DBA Data[Home] [Help]

APPS.IEX_SCORE_CASE_PVT dependencies on IEX_SCORE_HISTORIES

Line 276: from iex_score_histories a

272: if l_lastScore is NULL then
273: BEGIN
274: select a.score_value
275: into l_LastScore
276: from iex_score_histories a
277: where a.SCORE_OBJECT_ID = p_case_id
278: and a.creation_date = (select max(b.creation_date)
279: from iex_score_histories b
280: where b.score_object_id = p_case_id

Line 279: from iex_score_histories b

275: into l_LastScore
276: from iex_score_histories a
277: where a.SCORE_OBJECT_ID = p_case_id
278: and a.creation_date = (select max(b.creation_date)
279: from iex_score_histories b
280: where b.score_object_id = p_case_id
281: AND b.score_object_code = 'IEX_CASES');
282:
283: EXCEPTION