DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_POOLS

Line 372: , OKL_POOLS pool

368: ------------------------------------------------------------
369: CURSOR c_sec_strm_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER, p_stream_element_date DATE) IS
370: select distinct khr.id khr_id
371: from okl_pool_contents_v pol
372: , OKL_POOLS pool
373: ,okl_k_headers_full_v khr
374: where pol.khr_id = p_khr_id
375: and nvl(pol.kle_id, -99) = nvl(p_kle_id, -99)
376: and pol.sty_id = p_sty_id

Line 524: FROM OKL_POOLS pool,

520: SELECT 'Y'
521: FROM dual
522: WHERE EXISTS(
523: SELECT 1
524: FROM OKL_POOLS pool,
525: okl_pool_contents_v poc,
526: okl_strm_type_v sty
527: WHERE pool.khr_id = p_khr_id AND
528: pool.id = poc.pol_id AND