APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKL_K_LINES_FULL_V

Line 2271: FROM okl_k_lines_full_v cle,

2267:
2268: /*CURSOR get_asset_info(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
2269: IS
2270: SELECT sum(cle.capital_amount) total_capital_amount
2271: FROM okl_k_lines_full_v cle,
2272: okc_line_styles_b lse
2273: WHERE cle.dnz_chr_id = p_chr_id
2274: AND cle.lse_id = lse.id
2275: AND lse.lty_code = G_FIN_LINE_LTY_CODE

Line 2328: FROM okl_k_lines_full_v cle,

2324: -- Get the fee links which are not corresponding to this contract
2325: CURSOR get_item_info(p_dnz_chr_Id OKC_K_HEADERS_V.ID%TYPE)
2326: IS
2327: SELECT DISTINCT(cle.id) id
2328: FROM okl_k_lines_full_v cle,
2329: okc_k_items cim
2330: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2331: AND cle.id = cim.cle_id
2332: AND cim.jtot_object1_code = 'OKX_COVASST'

Line 2579: FROM okl_k_lines_full_v klfv

2575: AND lse.lty_code = 'SOLD_SERVICE'
2576: AND lse.lse_type = 'TLS'
2577: AND cle.cle_id IS NULL
2578: AND cle.id = (SELECT klfv.ORIG_SYSTEM_ID1
2579: FROM okl_k_lines_full_v klfv
2580: WHERE klfv.id = p_new_cle_id
2581: AND klfv.dnz_chr_id = p_new_chr_id);
2582:
2583: