APPS.OKL_PAYMENT_SPLIT_PVT dependencies on OKL_K_LINES_FULL_V

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

78: l_cap_amount NUMBER;
79:
80: CURSOR cap_csr (p_fin_line_id NUMBER) IS
81: SELECT SUM(NVL(okl1.capital_amount,0))
82: FROM okl_k_lines_full_v okl1, -- fee sub line
83: okl_k_lines_full_v okl2, -- fee top line
84: okc_k_items_v item1,
85: okc_k_items_v item2,
86: okl_strmtyp_source_v stream

Line 83: okl_k_lines_full_v okl2, -- fee top line

79:
80: CURSOR cap_csr (p_fin_line_id NUMBER) IS
81: SELECT SUM(NVL(okl1.capital_amount,0))
82: FROM okl_k_lines_full_v okl1, -- fee sub line
83: okl_k_lines_full_v okl2, -- fee top line
84: okc_k_items_v item1,
85: okc_k_items_v item2,
86: okl_strmtyp_source_v stream
87: WHERE item1.object1_id1 = TO_CHAR(p_fin_line_id) -- Bug 3830454

Line 356: FROM okl_k_lines_full_v line

352:
353: -- Total Capital amount from Financial Asset Top line
354: CURSOR fin_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
355: SELECT SUM(NVL(line.capital_amount,0))
356: FROM okl_k_lines_full_v line
357: WHERE line.dnz_chr_id = p_chr_id
358: AND EXISTS ( SELECT 'Y'
359: FROM okc_line_styles_v style
360: WHERE line.lse_id = style.id

Line 373: FROM okl_k_lines_full_v line,

369:
370: -- Total Capital amount from FEE Top Line
371: CURSOR fee_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
372: SELECT SUM(NVL(line.capital_amount,0))
373: FROM okl_k_lines_full_v line,
374: okc_line_styles_v style,
375: okc_k_items_v item,
376: okl_strmtyp_source_v stream
377: WHERE style.lty_code = 'FEE'

Line 479: FROM okl_k_lines_full_v okl,

475: l_precision FND_CURRENCIES.PRECISION%TYPE;
476:
477: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
478: SELECT okl.*
479: FROM okl_k_lines_full_v okl,
480: okc_line_styles_b ols
481: WHERE okl.dnz_chr_id = p_chr_id
482: AND okl.lse_id = ols.id
483: AND ols.lty_code = 'FREE_FORM1'