APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_LINE_STYLES_V

Line 1473: FROM okc_line_styles_v style

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

Line 2218: okc_line_styles_v ols,

2214: ) IS
2215: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2216: SELECT okl.id, okl.capital_amount
2217: FROM okl_k_lines_full_v okl,
2218: okc_line_styles_v ols,
2219: okc_rule_groups_b rgp,
2220: okc_rules_b rul
2221: WHERE okl.dnz_chr_id = p_chr_id
2222: AND okl.lse_id = ols.id

Line 2258: okc_line_styles_v style,

2254:
2255: CURSOR line_cap_csr (p_chr_id NUMBER) IS
2256: SELECT SUM(NVL(line.oec,0)) tot_cap
2257: FROM okl_k_lines_full_v line,
2258: okc_line_styles_v style,
2259: okc_statuses_v okcsts,
2260: okc_rules_b rule,
2261: okc_rule_groups_b rgp
2262: WHERE line.dnz_chr_id = p_chr_id