DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_POOLS

Line 326: , OKL_POOLS pool

322: ------------------------------------------------------------
323: CURSOR c_sec_strm_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER, p_stream_element_date DATE) IS
324: select distinct khr.id khr_id
325: from okl_pool_contents_v pol
326: , OKL_POOLS pool
327: ,okl_k_headers_full_v khr
328: where pol.khr_id = p_khr_id
329: and nvl(pol.kle_id, -99) = nvl(p_kle_id, -99)
330: and pol.sty_id = p_sty_id

Line 478: FROM OKL_POOLS pool,

474: SELECT 'Y'
475: FROM dual
476: WHERE EXISTS(
477: SELECT 1
478: FROM OKL_POOLS pool,
479: okl_pool_contents_v poc,
480: okl_strm_type_v sty
481: WHERE pool.khr_id = p_khr_id AND
482: pool.id = poc.pol_id AND