APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKC_K_LINES_V

Line 5080: FROM OKC_K_LINES_V cle,

5076: SELECT kle.OEC,
5077: kle.RESIDUAL_VALUE,
5078: cle.id,
5079: cle.name
5080: FROM OKC_K_LINES_V cle,
5081: OKC_LINE_STYLES_B lse,
5082: OKL_K_LINES kle,
5083: OKC_K_LINES_B fa_cle,
5084: OKC_LINE_STYLES_B fa_cle_lse

Line 5107: l_cle_id OKC_K_LINES_V.ID%TYPE;

5103: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
5104:
5105: l_oec OKL_K_LINES.OEC%TYPE;
5106: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
5107: l_cle_id OKC_K_LINES_V.ID%TYPE;
5108: l_asset_number OKC_K_LINES_V.NAME%TYPE;
5109:
5110:
5111: --cursor to get the modified transaction values against the rebook contract

Line 5108: l_asset_number OKC_K_LINES_V.NAME%TYPE;

5104:
5105: l_oec OKL_K_LINES.OEC%TYPE;
5106: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
5107: l_cle_id OKC_K_LINES_V.ID%TYPE;
5108: l_asset_number OKC_K_LINES_V.NAME%TYPE;
5109:
5110:
5111: --cursor to get the modified transaction values against the rebook contract
5112: CURSOR adj_txl_csr (p_rbk_chr_id IN NUMBER, p_effective_date IN DATE ) IS

Line 5300: From okc_k_lines_v clev,

5296: CURSOR new_ast_csr (p_rbk_chr_id IN NUMBER) is
5297: Select clev.id new_fin_cle_id,
5298: fa_cle.id new_fa_cle_id,
5299: clev.chr_id orig_chr_id
5300: From okc_k_lines_v clev,
5301: okc_line_styles_b lse,
5302: okc_k_lines_b fa_cle,
5303: okc_line_styles_b fa_lse,
5304: okc_k_headers_b chr

Line 5310: from okc_k_lines_v rbk_line

5306: and clev.dnz_chr_id = chr.orig_system_id1
5307: and chr.id = p_rbk_chr_id
5308: and chr.orig_system_source_code = 'OKL_REBOOK'
5309: and exists (select null
5310: from okc_k_lines_v rbk_line
5311: where rbk_line.chr_id = chr.id
5312: and rbk_line.dnz_chr_id = chr.id
5313: and rbk_line.lse_id = clev.lse_id
5314: and rbk_line.name = clev.name

Line 6365: FROM OKC_K_LINES_V cle,

6361: SELECT kle.OEC,
6362: kle.RESIDUAL_VALUE,
6363: cle.id,
6364: cle.name
6365: FROM OKC_K_LINES_V cle,
6366: OKC_LINE_STYLES_B lse,
6367: OKL_K_LINES kle,
6368: OKC_K_LINES_B fa_cle,
6369: OKC_LINE_STYLES_B fa_cle_lse

Line 6392: l_cle_id OKC_K_LINES_V.ID%TYPE;

6388: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));
6389:
6390: l_oec OKL_K_LINES.OEC%TYPE;
6391: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6392: l_cle_id OKC_K_LINES_V.ID%TYPE;
6393: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6394:
6395:
6396: --cursor to get the modified transaction values against the rebook contract

Line 6393: l_asset_number OKC_K_LINES_V.NAME%TYPE;

6389:
6390: l_oec OKL_K_LINES.OEC%TYPE;
6391: l_residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE;
6392: l_cle_id OKC_K_LINES_V.ID%TYPE;
6393: l_asset_number OKC_K_LINES_V.NAME%TYPE;
6394:
6395:
6396: --cursor to get the modified transaction values against the rebook contract
6397: CURSOR adj_txl_csr (p_rbk_chr_id IN NUMBER, p_effective_date IN DATE ) IS

Line 9585: from okc_k_lines_v

9581:
9582: --Bug# 4775166
9583: Cursor l_clev_csr(p_cle_id in number) is
9584: select name
9585: from okc_k_lines_v
9586: where id = p_cle_id;
9587:
9588: l_clev_rec l_clev_csr%rowtype;
9589: