APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKS_STREAM_LEVELS_B

Line 1974: FROM oks_stream_levels_b

1970: advance_periods,
1971: amount,
1972: invoice_offset_days,
1973: due_arr_yn
1974: FROM oks_stream_levels_b
1975: WHERE dnz_chr_id = chrid AND NVL (cle_id, -1) = cleid
1976: ORDER BY sequence_no;
1977:
1978: l_rl_oks_v10_rec l_rl_oks_v10_csr%ROWTYPE;

Line 2002: FROM oks_level_elements_v schd, oks_stream_levels_b strm

1998:
1999: --Bug# 3257597 : 11.5.10 OKS Rule Migration Impact
2000: CURSOR l_oks_v10_csr (cleid NUMBER, dt DATE) IS
2001: SELECT schd.date_to_interface
2002: FROM oks_level_elements_v schd, oks_stream_levels_b strm
2003: WHERE schd.rul_id = strm.ID
2004: AND strm.cle_id = cleid
2005: AND schd.date_to_interface >= dt
2006: ORDER BY schd.date_to_interface;

Line 2084: oks_stream_levels_b strm

2080: AND strm.active_yn = 'Y'
2081: AND EXISTS (
2082: SELECT schd.date_to_interface
2083: FROM oks_level_elements_v schd,
2084: oks_stream_levels_b strm
2085: WHERE schd.rul_id = strm.ID
2086: AND strm.cle_id = p_oks_cov_prod
2087: AND schd.date_to_interface =
2088: ele.stream_element_date));