DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_LINES_V

Line 4017: l_fee_name OKC_K_LINES_V.NAME%TYPE;

4013: l_amt NUMBER;
4014: l_found VARCHAR2(1);
4015: l_k_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
4016: l_q_num OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE;
4017: l_fee_name OKC_K_LINES_V.NAME%TYPE;
4018:
4019: l_rebook_yn VARCHAR2(1) := null;
4020: l_ln_orig_sys_id1 okc_k_lines_b.orig_system_id1%type := null;
4021: l_mass_rebook_cnt NUMBER := null;

Line 4040: okc_k_lines_v cle,

4036: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4037: SELECT cle.name
4038: FROM okc_k_headers_b khr,
4039: okl_k_lines kle,
4040: okc_k_lines_v cle,
4041: okl_trx_quotes_b qte
4042: WHERE cle.id = kle.id
4043: AND khr.id = chrID
4044: AND khr.id = cle.dnz_chr_id

Line 5239: FROM okc_k_lines_v cle,

5235: --Bug# 4899328
5236: CURSOR c_assets(p_chr_id IN NUMBER) IS
5237: SELECT cle.id fin_asset_id,
5238: cle.name asset_number
5239: FROM okc_k_lines_v cle,
5240: okc_line_styles_b lse,
5241: okc_statuses_b sts
5242: WHERE cle.chr_id = p_chr_id
5243: AND cle.dnz_chr_id = p_chr_id