APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKL_K_LINES_FULL_V

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

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

Line 258: okl_k_lines_full_v okl2, -- fee top line

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

Line 1466: FROM okl_k_lines_full_v line

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

Line 1560: FROM okl_k_lines_full_v okl,

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

Line 1857: FROM okl_k_lines_full_v okl,

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

Line 1897: FROM okl_k_lines_full_v line,

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