APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_K_LINES_V

Line 627: okc_k_lines_v cle

623: DECODE(NVL(vip.catchup_amt,0),0,' ',OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.catchup_amt,0),chr.currency_code)) catchup_amt,
624: vip.catchup_settlement_code
625: FROM okl_var_int_params vip,
626: okc_k_headers_b chr,
627: okc_k_lines_v cle
628: WHERE chr.id = p_contract_id
629: AND vip.khr_id = chr.id
630: AND vip.request_id = g_request_id
631: AND vip.kle_id = cle.id

Line 644: l_asset_number OKC_K_LINES_V.NAME%TYPE;

640:
641: l_catchup_settlement_desc VARCHAR2(2000);
642: --Bug# 12974796
643:
644: l_asset_number OKC_K_LINES_V.NAME%TYPE;
645: l_display_asset_number OKC_K_LINES_V.NAME%TYPE;
646:
647: CURSOR var_int_params_contract_csr (p_contract_id NUMBER) IS
648: SELECT vip.interest_calc_start_date,

Line 645: l_display_asset_number OKC_K_LINES_V.NAME%TYPE;

641: l_catchup_settlement_desc VARCHAR2(2000);
642: --Bug# 12974796
643:
644: l_asset_number OKC_K_LINES_V.NAME%TYPE;
645: l_display_asset_number OKC_K_LINES_V.NAME%TYPE;
646:
647: CURSOR var_int_params_contract_csr (p_contract_id NUMBER) IS
648: SELECT vip.interest_calc_start_date,
649: vip.interest_calc_end_date,

Line 2841: FROM okc_k_lines_v cle,

2837: ORDER BY start_date;
2838:
2839: CURSOR l_assets_csr(p_contract_id NUMBER) IS
2840: SELECT cle.id
2841: FROM okc_k_lines_v cle,
2842: okc_line_styles_b sty,
2843: okc_statuses_b sts
2844: WHERE cle.lse_id = sty.id
2845: AND cle.dnz_chr_id = p_contract_id