DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_POOL_CONTENTS_V

Line 325: from okl_pool_contents_v pol

321: -- Find out whether the stream was securitized
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)

Line 479: okl_pool_contents_v poc,

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
483: poc.sty_id = sty.id AND