APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKS_STREAM_LEVELS_B

Line 1670: FROM oks_stream_levels_b

1666: advance_periods,
1667: amount,
1668: invoice_offset_days,
1669: due_arr_yn
1670: FROM oks_stream_levels_b
1671: WHERE dnz_chr_id = chrid AND NVL (cle_id, -1) = cleid
1672: ORDER BY sequence_no;
1673:
1674: l_rl_oks_v10_rec l_rl_oks_v10_csr%ROWTYPE;

Line 1698: FROM oks_level_elements_v schd, oks_stream_levels_b strm

1694:
1695: --Bug# 3257597 : 11.5.10 OKS Rule Migration Impact
1696: CURSOR l_oks_v10_csr (cleid NUMBER, dt DATE) IS
1697: SELECT schd.date_to_interface
1698: FROM oks_level_elements_v schd, oks_stream_levels_b strm
1699: WHERE schd.rul_id = strm.ID
1700: AND strm.cle_id = cleid
1701: AND schd.date_to_interface >= dt
1702: ORDER BY schd.date_to_interface;

Line 1780: oks_stream_levels_b strm

1776: AND strm.active_yn = 'Y'
1777: AND EXISTS (
1778: SELECT schd.date_to_interface
1779: FROM oks_level_elements_v schd,
1780: oks_stream_levels_b strm
1781: WHERE schd.rul_id = strm.ID
1782: AND strm.cle_id = p_oks_cov_prod
1783: AND schd.date_to_interface =
1784: ele.stream_element_date));