APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKS_LEVEL_ELEMENTS_V

Line 1986: oks_level_elements_v schd

1982: SELECT schd.date_to_interface
1983: FROM okc_rules_v rule,
1984: okc_rule_groups_v rg,
1985: okc_k_lines_v line,
1986: oks_level_elements_v schd
1987: WHERE rg.ID = rule.rgp_id
1988: AND rg.cle_id = line.ID
1989: AND schd.rul_id = rule.ID
1990: AND line.ID = cleid

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

2040: SELECT schd.date_to_interface
2041: FROM okc_rules_v rule,
2042: okc_rule_groups_v rg,
2043: okc_k_lines_v line,
2044: oks_level_elements_v schd
2045: WHERE rg.ID = rule.rgp_id
2046: AND rg.cle_id = line.ID
2047: AND schd.rul_id = rule.ID
2048: AND line.ID =

Line 2083: FROM oks_level_elements_v schd,

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