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 3234: FROM okl_trx_assets tas

3230: AND cle.cle_id = p_kle_id -- top line id
3231: AND tal.dnz_khr_id = p_dnz_chr_id
3232: -- link from okl_pool_srch_v pol
3233: AND EXISTS (SELECT '1'
3234: FROM okl_trx_assets tas
3235: WHERE tas.id = tal.tas_id
3236: AND tas.tas_type = 'ALI'
3237: AND tas.tsu_code NOT IN ('PROCESSED','CANCELED')
3238: );

Line 4186: FROM okl_trx_assets tas

4182: AND talb.TAL_TYPE = 'ALI'
4183: AND cleb.cle_id = poc.kle_id -- top line id
4184: AND talb.dnz_khr_id = poc.khr_id
4185: AND EXISTS (SELECT '1'
4186: FROM okl_trx_assets tas
4187: WHERE tas.id = talb.tas_id
4188: AND tas.tas_type = 'ALI'
4189: AND tas.tsu_code = 'PROCESSED')
4190: );

Line 4371: FROM okl_trx_assets tas

4367: AND talb.TAL_TYPE = 'ALI'
4368: AND cleb.cle_id = poc.kle_id -- top line id
4369: AND talb.dnz_khr_id = poc.khr_id
4370: AND EXISTS (SELECT '1'
4371: FROM okl_trx_assets tas
4372: WHERE tas.id = talb.tas_id
4373: AND tas.tas_type = 'ALI'
4374: AND tas.tsu_code = 'PROCESSED')
4375: );