APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKS_LEVEL_ELEMENTS_V

Line 1682: oks_level_elements_v schd

1678: SELECT schd.date_to_interface
1679: FROM okc_rules_v rule,
1680: okc_rule_groups_v rg,
1681: okc_k_lines_v line,
1682: oks_level_elements_v schd
1683: WHERE rg.ID = rule.rgp_id
1684: AND rg.cle_id = line.ID
1685: AND schd.rul_id = rule.ID
1686: AND line.ID = cleid

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 1740: oks_level_elements_v schd

1736: SELECT schd.date_to_interface
1737: FROM okc_rules_v rule,
1738: okc_rule_groups_v rg,
1739: okc_k_lines_v line,
1740: oks_level_elements_v schd
1741: WHERE rg.ID = rule.rgp_id
1742: AND rg.cle_id = line.ID
1743: AND schd.rul_id = rule.ID
1744: AND line.ID =

Line 1779: FROM oks_level_elements_v schd,

1775: AND strm.say_code = 'CURR'
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 =