APPS.OKL_POOL_PVT dependencies on IEX_DELINQUENCIES_ALL

Line 2704: iex_delinquencies_all del

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)
2708: AND NOT EXISTS -- contract line has been terminated

Line 2831: iex_delinquencies_all del

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)
2835: AND NOT EXISTS -- contract line has been terminated

Line 3251: iex_delinquencies_all del

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;
3255:

Line 4152: iex_delinquencies_all del

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
4156: -- cklee 04/10/2003 never reconcile historical data

Line 4338: iex_delinquencies_all del

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
4342: -- cklee 04/10/2003 never reconcile historical data