APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_K_LINES_V

Line 1681: okc_k_lines_v line,

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

Line 1739: okc_k_lines_v line,

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

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

3340: -- nikshah -- Bug # 5484903 Fixed,
3341: -- Changed CURSOR l_k_std_csr SQL definition
3342: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3343: SELECT 1
3344: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3345: WHERE khr.ID = chrid
3346: AND cleb.dnz_chr_id = khr.ID
3347: AND kle.ID = cleb.ID
3348: AND kle.fee_type = 'ROLLOVER'

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

3363: -- nikshah -- Bug # 5484903 Fixed,
3364: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3365: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3366: SELECT 1
3367: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3368: WHERE khr.ID = chrid
3369: AND cleb.dnz_chr_id = khr.ID
3370: AND kle.ID = cleb.ID
3371: AND kle.fee_type = 'ROLLOVER'