APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_LINES_V

Line 4004: l_fee_name OKC_K_LINES_V.NAME%TYPE;

4000: l_amt NUMBER;
4001: l_found VARCHAR2(1);
4002: l_k_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
4003: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;
4004: l_fee_name OKC_K_LINES_V.NAME%TYPE;
4005:
4006: l_rebook_yn VARCHAR2(1) := null;
4007: l_ln_orig_sys_id1 okc_k_lines_b.orig_system_id1%type := null;
4008: l_mass_rebook_cnt NUMBER := null;

Line 4027: okc_k_lines_v cle,

4023: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4024: SELECT cle.name
4025: FROM okc_k_headers_b khr,
4026: okl_k_lines kle,
4027: okc_k_lines_v cle,
4028: okl_trx_quotes_b qte
4029: WHERE cle.id = kle.id
4030: AND khr.id = chrID
4031: AND khr.id = cle.dnz_chr_id

Line 5226: FROM okc_k_lines_v cle,

5222: --Bug# 4899328
5223: CURSOR c_assets(p_chr_id IN NUMBER) IS
5224: SELECT cle.id fin_asset_id,
5225: cle.name asset_number
5226: FROM okc_k_lines_v cle,
5227: okc_line_styles_b lse,
5228: okc_statuses_b sts
5229: WHERE cle.chr_id = p_chr_id
5230: AND cle.dnz_chr_id = p_chr_id