APPS.OKL_POOL_PVT dependencies on OKL_TRX_ASSETS

Line 2697: FROM okl_trx_assets tas

2693: AND cle.cle_id = pol.kle_id -- top line id
2694: AND tal.dnz_khr_id = pol.dnz_chr_id
2695: -- link from okl_pool_srch_v pol
2696: AND EXISTS (SELECT '1'
2697: FROM okl_trx_assets tas
2698: WHERE tas.id = tal.tas_id
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

Line 2824: FROM okl_trx_assets tas

2820: AND cle.cle_id = pol.kle_id -- top line id
2821: AND tal.dnz_khr_id = pol.dnz_chr_id
2822: -- link from okl_pool_srch_v pol
2823: AND EXISTS (SELECT '1'
2824: FROM okl_trx_assets tas
2825: WHERE tas.id = tal.tas_id
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

Line 3240: FROM okl_trx_assets tas

3236: AND cle.cle_id = p_kle_id -- top line id
3237: AND tal.dnz_khr_id = p_dnz_chr_id
3238: -- link from okl_pool_srch_v pol
3239: AND EXISTS (SELECT '1'
3240: FROM okl_trx_assets tas
3241: WHERE tas.id = tal.tas_id
3242: AND tas.tas_type = 'ALI'
3243: AND tas.tsu_code NOT IN ('PROCESSED','CANCELED')
3244: );

Line 4192: FROM okl_trx_assets tas

4188: AND talb.TAL_TYPE = 'ALI'
4189: AND cleb.cle_id = poc.kle_id -- top line id
4190: AND talb.dnz_khr_id = poc.khr_id
4191: AND EXISTS (SELECT '1'
4192: FROM okl_trx_assets tas
4193: WHERE tas.id = talb.tas_id
4194: AND tas.tas_type = 'ALI'
4195: AND tas.tsu_code = 'PROCESSED')
4196: );

Line 4378: FROM okl_trx_assets tas

4374: AND talb.TAL_TYPE = 'ALI'
4375: AND cleb.cle_id = poc.kle_id -- top line id
4376: AND talb.dnz_khr_id = poc.khr_id
4377: AND EXISTS (SELECT '1'
4378: FROM okl_trx_assets tas
4379: WHERE tas.id = talb.tas_id
4380: AND tas.tas_type = 'ALI'
4381: AND tas.tsu_code = 'PROCESSED')
4382: );