APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_LINE_STYLES_V

Line 1469: FROM okc_line_styles_v style

1465: SELECT SUM(NVL(line.capital_amount,0))
1466: FROM okl_k_lines_full_v line
1467: WHERE line.dnz_chr_id = p_chr_id
1468: AND EXISTS ( SELECT 'Y'
1469: FROM okc_line_styles_v style
1470: WHERE line.lse_id = style.id
1471: AND style.lty_code = 'FREE_FORM1'
1472: )
1473: -- added to handle abandon line

Line 1858: okc_line_styles_v ols,

1854: ) IS
1855: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1856: SELECT okl.id, okl.capital_amount
1857: FROM okl_k_lines_full_v okl,
1858: okc_line_styles_v ols,
1859: okc_rule_groups_b rgp,
1860: okc_rules_b rul
1861: WHERE okl.dnz_chr_id = p_chr_id
1862: AND okl.lse_id = ols.id

Line 1898: okc_line_styles_v style,

1894:
1895: CURSOR line_cap_csr (p_chr_id NUMBER) IS
1896: SELECT SUM(NVL(line.oec,0)) tot_cap
1897: FROM okl_k_lines_full_v line,
1898: okc_line_styles_v style,
1899: okc_statuses_v okcsts,
1900: okc_rules_b rule,
1901: okc_rule_groups_b rgp
1902: WHERE line.dnz_chr_id = p_chr_id