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 3245: iex_delinquencies_all del

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

Line 4146: iex_delinquencies_all del

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

Line 4331: iex_delinquencies_all del

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