APPS.IEX_ASSIGN_COLL_LEVEL_PVT dependencies on IEX_SCORE_HISTORIES

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 25: --(select max(sh.request_id) from iex_score_histories sh where score_object_code <> 'IEX_INVOICES')

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')
26: and ish.score_object_code = p_code; --<> 'IEX_INVOICES';
27:
28:
29: Cursor C_get_PartyId_Account(id number) is

Line 44: select shs.score_object_code from iex_score_histories shs where shs.score_history_id = (select max(score_history_id)

40: select party_cust_id from iex_delinquencies
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

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');

Line 109: select max(request_id) into l_req_id from iex_score_histories where score_object_code <> 'IEX_INVOICES';

105: into l_party_level,l_using_del_level,l_using_billto_level,l_using_acc_level,l_using_cust_level
106: from iex_questionnaire_items;
107:
108: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Starting MAIN PROCESS .....');
109: select max(request_id) into l_req_id from iex_score_histories where score_object_code <> 'IEX_INVOICES';
110:
111: --Begin Bug 8839374 16-Feb-2010 barathsr
112: if l_party_level <> 'Y' then
113: if FND_GLOBAL.Conc_Request_Id is not null then