DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_LINE_STYLES_B

Line 85: okc_line_styles_b lsb

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

Line 173: okc_line_styles_b lsb

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

Line 1561: okc_line_styles_b ols,

1557: --Changed query for performance --dkagrawa
1558: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1559: SELECT okl.*
1560: FROM okl_k_lines_full_v okl,
1561: okc_line_styles_b ols,
1562: okc_statuses_b okcsts
1563: WHERE okl.dnz_chr_id = p_chr_id
1564: AND okl.lse_id = ols.id
1565: AND ols.lty_code = 'FREE_FORM1'