APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKC_K_LINES_V

Line 5260: From okc_k_lines_v clev,

5256: CURSOR new_ast_csr (p_rbk_chr_id IN NUMBER) is
5257: Select clev.id new_fin_cle_id,
5258: fa_cle.id new_fa_cle_id,
5259: clev.chr_id orig_chr_id
5260: From okc_k_lines_v clev,
5261: okc_line_styles_b lse,
5262: okc_k_lines_b fa_cle,
5263: okc_line_styles_b fa_lse,
5264: okc_k_headers_b chr

Line 5270: from okc_k_lines_v rbk_line

5266: and clev.dnz_chr_id = chr.orig_system_id1
5267: and chr.id = p_rbk_chr_id
5268: and chr.orig_system_source_code = 'OKL_REBOOK'
5269: and exists (select null
5270: from okc_k_lines_v rbk_line
5271: where rbk_line.chr_id = chr.id
5272: and rbk_line.dnz_chr_id = chr.id
5273: and rbk_line.lse_id = clev.lse_id
5274: and rbk_line.name = clev.name

Line 6299: FROM OKC_K_LINES_V cle,

6295: SELECT kle.OEC,
6296: kle.RESIDUAL_VALUE,
6297: cle.id,
6298: cle.name
6299: FROM OKC_K_LINES_V cle,
6300: OKC_LINE_STYLES_B lse,
6301: OKL_K_LINES kle,
6302: OKC_K_LINES_B fa_cle,
6303: OKC_LINE_STYLES_B fa_cle_lse

Line 6326: l_cle_id OKC_K_LINES_V.ID%TYPE;

6322: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
6323:
6324: l_oec OKL_K_LINES.OEC%TYPE;
6325: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6326: l_cle_id OKC_K_LINES_V.ID%TYPE;
6327: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6328: */
6329:
6330: --cursor to get the modified transaction values against the rebook contract

Line 6327: l_asset_number OKC_K_LINES_V.NAME%TYPE;

6323:
6324: l_oec OKL_K_LINES.OEC%TYPE;
6325: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6326: l_cle_id OKC_K_LINES_V.ID%TYPE;
6327: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6328: */
6329:
6330: --cursor to get the modified transaction values against the rebook contract
6331: CURSOR adj_txl_csr (p_rbk_chr_id IN NUMBER, p_effective_date IN DATE ) IS

Line 9310: from okc_k_lines_v

9306:
9307: --Bug# 4775166
9308: Cursor l_clev_csr(p_cle_id in number) is
9309: select name
9310: from okc_k_lines_v
9311: where id = p_cle_id;
9312:
9313: l_clev_rec l_clev_csr%rowtype;
9314: