APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_LINE_STYLES_B

Line 89: okc_line_styles_b lsb

85: SELECT 'Y'
86: FROM okc_rules_v rule,
87: okc_rule_groups_v rg,
88: okc_k_lines_b cle,
89: okc_line_styles_b lsb
90: WHERE rule.dnz_chr_id = p_chr_id
91: AND rule_information_category IN ('LASLH','LASLL')
92: AND rule.object1_id1 = p_strm_id
93: AND rg.cle_id IS NOT NULL

Line 177: okc_line_styles_b lsb

173: FROM okc_rules_v rule,
174: okc_rule_groups_v rg,
175: okc_k_lines_b cleb, -- Top Line
176: okc_k_lines_b cle, -- Sub Line
177: okc_line_styles_b lsb
178: WHERE rule.dnz_chr_id = p_chr_id
179: AND rule_information_category IN ('LASLH','LASLL')
180: AND rule.object1_id1 = p_strm_id
181: AND cleb.id = p_cle_id -- Top Line

Line 1886: okc_line_styles_b ols,

1882: --Changed query for performance --dkagrawa
1883: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1884: SELECT okl.id, okl.capital_amount -- bug# 7661717
1885: FROM okl_k_lines_full_v okl,
1886: okc_line_styles_b ols,
1887: okc_statuses_b okcsts
1888: WHERE okl.dnz_chr_id = p_chr_id
1889: AND okl.lse_id = ols.id
1890: AND ols.lty_code = 'FREE_FORM1'