APPS.OKL_POOL_PVT dependencies on OKL_STRM_TYPE_B

Line 2658: okl_strm_type_b styb

2654: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2655: AND NOT EXISTS -- okl_pool_contents
2656: (SELECT '1'
2657: FROM okl_pool_contents pol_cnts,
2658: okl_strm_type_b styb
2659: WHERE pol_cnts.pol_id = pol_id
2660: -- mvasudev, stm_id changes
2661: -- AND pol_cnts.sty_id = styb.id
2662: -- AND pol.dnz_chr_id = pol_cnts.khr_id

Line 2786: okl_strm_type_b styb

2782: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2783: AND NOT EXISTS -- okl_pool_contents
2784: (SELECT '1'
2785: FROM okl_pool_contents pol_cnts,
2786: okl_strm_type_b styb
2787: WHERE pol_cnts.pol_id = pol_id
2788: -- mvasudev, stm_id changes
2789: --AND pol_cnts.sty_id = styb.id
2790: --AND pol.dnz_chr_id = pol_cnts.khr_id

Line 3158: okl_strm_type_b styb,

3154: CURSOR l_okl_dup_pocs_csr(p_stream_type_subclass IN VARCHAR2,p_stm_id IN NUMBER)
3155: IS
3156: SELECT '1'
3157: FROM okl_pool_contents pol_cnts,
3158: okl_strm_type_b styb,
3159: okl_strm_elements sel
3160: WHERE pol_cnts.pol_id = pol_id
3161: AND pol_cnts.stm_id = p_stm_id
3162: AND styb.stream_type_subclass = p_stream_type_subclass

Line 4114: okl_strm_type_b sty,

4110: -- to remove all the rent strms if the contract turns to EVERGREEN--
4111: SELECT poc.id
4112: FROM okl_pool_contents poc,
4113: okl_pools pol,
4114: okl_strm_type_b sty,
4115: okc_k_headers_b CHR
4116: WHERE pol.id = p_pol_id
4117: AND pol.id = poc.pol_id
4118: AND poc.sty_id = sty.id

Line 4299: okl_strm_type_b sty,

4295: -- to remove all the rent strms if the contract turns to EVERGREEN--
4296: SELECT poc.id
4297: FROM okl_pool_contents poc,
4298: okl_pools pol,
4299: okl_strm_type_b sty,
4300: okc_k_headers_b CHR
4301: WHERE pol.id = p_pol_id
4302: AND pol.id = poc.pol_id
4303: AND poc.sty_id = sty.id