APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_K_LINES_V

Line 1985: okc_k_lines_v line,

1981: CURSOR l_oks_csr (cleid NUMBER, dt DATE) IS
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

Line 2043: okc_k_lines_v line,

2039: AND EXISTS (
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

Line 3647: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr

3643: -- nikshah -- Bug # 5484903 Fixed,
3644: -- Changed CURSOR l_k_std_csr SQL definition
3645: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3646: SELECT 1
3647: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3648: WHERE khr.ID = chrid
3649: AND cleb.dnz_chr_id = khr.ID
3650: AND kle.ID = cleb.ID
3651: AND kle.fee_type = 'ROLLOVER'

Line 3670: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr

3666: -- nikshah -- Bug # 5484903 Fixed,
3667: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3668: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3669: SELECT 1
3670: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3671: WHERE khr.ID = chrid
3672: AND cleb.dnz_chr_id = khr.ID
3673: AND kle.ID = cleb.ID
3674: AND kle.fee_type = 'ROLLOVER'