APPS.IEX_ASSIGN_COLL_LEVEL_PVT dependencies on IEX_SCORES

Line 21: select distinct ish.score_object_code,ish.score_object_id from iex_score_histories ish, iex_scores sc

17: RETCODE OUT NOCOPY Varchar2,
18: p_request_id IN Number) is
19:
20: Cursor C_get_CodeIds(p_code varchar2,p_id number) is
21: select distinct ish.score_object_code,ish.score_object_id from iex_score_histories ish, iex_scores sc
22: where ish.score_id = sc.score_id
23: and sc.concurrent_prog_name = 'IEXACLSB'
24: and ish.request_id = p_id
25: --(select max(sh.request_id) from iex_score_histories sh where score_object_code <> 'IEX_INVOICES')

Line 45: from iex_score_histories ish, iex_scores sc

41: where delinquency_id = id;
42:
43: Cursor C_get_objCode(p_id number) is
44: select shs.score_object_code from iex_score_histories shs where shs.score_history_id = (select max(score_history_id)
45: from iex_score_histories ish, iex_scores sc
46: where ish.score_id = sc.score_id
47: and sc.concurrent_prog_name = 'IEXACLSB'
48: and ish.request_id = p_id
49: and ish.score_object_code <> 'IEX_INVOICES');