APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKL_K_LINES_FULL_V

Line 261: FROM okl_k_lines_full_v okl1, -- fee sub line

257: l_cap_amount NUMBER;
258:
259: CURSOR cap_csr (p_fin_line_id NUMBER) IS
260: SELECT SUM(NVL(okl1.capital_amount,0))
261: FROM okl_k_lines_full_v okl1, -- fee sub line
262: okl_k_lines_full_v okl2, -- fee top line
263: okc_k_items_v item1,
264: okc_k_items_v item2,
265: okl_strmtyp_source_v stream

Line 262: okl_k_lines_full_v okl2, -- fee top line

258:
259: CURSOR cap_csr (p_fin_line_id NUMBER) IS
260: SELECT SUM(NVL(okl1.capital_amount,0))
261: FROM okl_k_lines_full_v okl1, -- fee sub line
262: okl_k_lines_full_v okl2, -- fee top line
263: okc_k_items_v item1,
264: okc_k_items_v item2,
265: okl_strmtyp_source_v stream
266: WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454

Line 1470: FROM okl_k_lines_full_v line

1466:
1467: -- Total Capital amount from Financial Asset Top line
1468: CURSOR fin_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
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

Line 1885: FROM okl_k_lines_full_v okl,

1881: ) IS
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

Line 2217: FROM okl_k_lines_full_v okl,

2213: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
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

Line 2257: FROM okl_k_lines_full_v line,

2253: AND rg.id = p_rgp_id;
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