DBA Data[Home] [Help]

APPS.IEX_CO_WF dependencies on IEX_DELINQUENCIES_ALL

Line 22: FROM iex_delinquencies_all ida

18: lx_msg_count NUMBER ;
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

Line 102: FROM iex_delinquencies_all ida

98: lx_msg_count NUMBER ;
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

Line 182: FROM iex_delinquencies_all ida

178: lx_msg_count NUMBER ;
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

Line 273: FROM iex_delinquencies_all ida

269: IOH.STATUS,
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

Line 377: FROM iex_delinquencies_all ida

373: IOH.OBJECT1_ID1,
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