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 3250: FROM iex_case_objects ico,

3246: -- contract is under deliquent status
3247: CURSOR l_okl_poc_delinq_csr(p_dnz_chr_id IN NUMBER)
3248: IS
3249: SELECT '1'
3250: FROM iex_case_objects ico,
3251: iex_delinquencies_all del
3252: WHERE ico. cas_id = del.case_id
3253: AND del.status ='DELINQUENT'
3254: AND ico.object_id = p_dnz_chr_id;

Line 4151: iex_case_objects ico,

4147: IS
4148: -- to remove all contents pointing to delinquent contracts
4149: SELECT poc.id
4150: FROM okl_pool_contents poc,
4151: iex_case_objects ico,
4152: iex_delinquencies_all del
4153: WHERE poc.pol_id = p_pol_id
4154: AND poc.khr_id = ico.object_id
4155: AND ico. cas_id = del.case_id

Line 4337: iex_case_objects ico,

4333: IS
4334: -- to remove all contents pointing to delinquent contracts
4335: SELECT poc.id
4336: FROM okl_pool_contents poc,
4337: iex_case_objects ico,
4338: iex_delinquencies_all del
4339: WHERE poc.pol_id = p_pol_id
4340: AND poc.khr_id = ico.object_id
4341: AND ico. cas_id = del.case_id