APPS.OKL_POOL_PVT dependencies on IEX_CASE_OBJECTS

Line 2703: FROM iex_case_objects ico,

2699: AND tas.tas_type = 'ALI'
2700: AND tas.tsu_code NOT IN ('PROCESSED','CANCELED')))--cklee 02/24/03
2701: AND NOT EXISTS -- contract is under deliquent status
2702: (SELECT '1'
2703: FROM iex_case_objects ico,
2704: iex_delinquencies_all del
2705: WHERE ico. cas_id = del.case_id
2706: AND del.status ='DELINQUENT'
2707: AND ico.object_id = pol.dnz_chr_id)

Line 2830: FROM iex_case_objects ico,

2826: AND tas.tas_type = 'ALI'
2827: AND tas.tsu_code NOT IN ('PROCESSED','CANCELED'))) -- cklee 02/24/03
2828: AND NOT EXISTS -- contract is under deliquent status
2829: (SELECT '1'
2830: FROM iex_case_objects ico,
2831: iex_delinquencies_all del
2832: WHERE ico. cas_id = del.case_id
2833: AND del.status ='DELINQUENT'
2834: AND ico.object_id = pol.dnz_chr_id)

Line 3244: FROM iex_case_objects ico,

3240: -- contract is under deliquent status
3241: CURSOR l_okl_poc_delinq_csr(p_dnz_chr_id IN NUMBER)
3242: IS
3243: SELECT '1'
3244: FROM iex_case_objects ico,
3245: iex_delinquencies_all del
3246: WHERE ico. cas_id = del.case_id
3247: AND del.status ='DELINQUENT'
3248: AND ico.object_id = p_dnz_chr_id;

Line 4145: iex_case_objects ico,

4141: IS
4142: -- to remove all contents pointing to delinquent contracts
4143: SELECT poc.id
4144: FROM okl_pool_contents poc,
4145: iex_case_objects ico,
4146: iex_delinquencies_all del
4147: WHERE poc.pol_id = p_pol_id
4148: AND poc.khr_id = ico.object_id
4149: AND ico. cas_id = del.case_id

Line 4330: iex_case_objects ico,

4326: IS
4327: -- to remove all contents pointing to delinquent contracts
4328: SELECT poc.id
4329: FROM okl_pool_contents poc,
4330: iex_case_objects ico,
4331: iex_delinquencies_all del
4332: WHERE poc.pol_id = p_pol_id
4333: AND poc.khr_id = ico.object_id
4334: AND ico. cas_id = del.case_id