DBA Data[Home] [Help]

APPS.IEX_CO_WF dependencies on IEX_CASE_OBJECTS

Line 23: ,iex_case_objects ico

19: lx_msg_data VARCHAR2(2000);
20:
21: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
22: FROM iex_delinquencies_all ida
23: ,iex_case_objects ico
24: WHERE ida.delinquency_id = cp_delinquency_id
25: AND ida.case_id = ico.cas_id;
26: BEGIN
27: if (funcmode = 'RUN') then

Line 103: ,iex_case_objects ico

99: lx_msg_data VARCHAR2(2000);
100:
101: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
102: FROM iex_delinquencies_all ida
103: ,iex_case_objects ico
104: WHERE ida.delinquency_id = cp_delinquency_id
105: AND ida.case_id = ico.cas_id;
106: BEGIN
107: if (funcmode = 'RUN') then

Line 183: ,iex_case_objects ico

179: lx_msg_data VARCHAR2(2000);
180:
181: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
182: FROM iex_delinquencies_all ida
183: ,iex_case_objects ico
184: WHERE ida.delinquency_id = cp_delinquency_id
185: AND ida.case_id = ico.cas_id;
186: BEGIN
187: if (funcmode = 'RUN') then

Line 274: ,iex_case_objects ico

270: IOH.REQUEST_DATE,
271: IOH.PROCESS_DATE,
272: IOH.EXT_AGNCY_ID
273: FROM iex_delinquencies_all ida
274: ,iex_case_objects ico
275: ,Okl_Open_Int OIN
276: ,Iex_Open_Int_Hst IOH
277: WHERE ida.delinquency_id = cp_delinquency_id
278: AND ida.case_id = ico.cas_id

Line 378: ,iex_case_objects ico

374: IOH.OBJECT1_ID2,
375: IOH.JTOT_OBJECT1_CODE,
376: IOH.EXT_AGNCY_ID
377: FROM iex_delinquencies_all ida
378: ,iex_case_objects ico
379: ,Okl_Open_Int OIN
380: ,Iex_Open_Int_Hst IOH
381: WHERE ida.delinquency_id = cp_delinquency_id
382: AND ida.case_id = ico.cas_id