DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_POOL_CONTENTS_V

Line 371: from okl_pool_contents_v pol

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

Line 525: okl_pool_contents_v poc,

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