APPS.OKL_AM_SV_WRITEDOWN_PVT dependencies on OKX_ASSET_LINES_V

Line 62: -- This cursor fetches the asset lines from okx_asset_lines_v corresponding to the parent_line_id passed as

58:
59: --SECHAWLA 03-JAN-03 Bug # 2683876 : new declaration
60: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
61:
62: -- This cursor fetches the asset lines from okx_asset_lines_v corresponding to the parent_line_id passed as
63: -- input parameter
64: CURSOR l_assetlinesv_csr(p_cle_id NUMBER) IS
65: SELECT to_number(l.asset_id) , l.asset_number, l.item_description, l.salvage_value, l.original_cost, l.current_units,
66: l.corporate_book, l.dnz_chr_id, h.contract_number

Line 67: FROM okx_asset_lines_v l, okc_k_headers_b h

63: -- input parameter
64: CURSOR l_assetlinesv_csr(p_cle_id NUMBER) IS
65: SELECT to_number(l.asset_id) , l.asset_number, l.item_description, l.salvage_value, l.original_cost, l.current_units,
66: l.corporate_book, l.dnz_chr_id, h.contract_number
67: FROM okx_asset_lines_v l, okc_k_headers_b h
68: WHERE l.dnz_chr_id = h.id
69: AND l.parent_line_id = p_cle_id;
70:
71:

Line 85: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okx_asset_lines_v l

81:
82: -- This cursor is used to check if an accepted termination quote exists for an asset line.
83: CURSOR l_quotes_csr(p_kle_id NUMBER) IS
84: SELECT l.asset_number
85: FROM okl_trx_quotes_b qh, okl_txl_quote_lines_b ql, okx_asset_lines_v l
86: WHERE qh.id = ql.qte_id
87: AND qh.qst_code = 'ACCEPTED'
88: AND ql.qlt_code = 'AMCFIA'
89: AND ql.kle_id = l.parent_line_id

Line 144: -- fetch the asset line information from okx_asset_lines_v for each cle_id in the input table,

140:
141:
142:
143: i := p_assets_tbl.FIRST;
144: -- fetch the asset line information from okx_asset_lines_v for each cle_id in the input table,
145: -- validate the old salvage value(in the view), new salvage value (in the input table) and then
146: -- create salvage value writedown transactions (FSC/FSL) in OKL tables.
147: LOOP
148: