APPS.OKL_LOSS_PROV_PVT dependencies on OKX_ASSET_LINES_V

Line 28: l_asset_id OKX_ASSET_LINES_V.ASSET_ID%TYPE;

24: -- Bug 5935176 dpsingh for AE signature Uptake end
25: -- this function is used to calculate net book value for a contract
26: FUNCTION calculate_cntrct_nbv (p_cntrct_id IN NUMBER) RETURN NUMBER
27: IS
28: l_asset_id OKX_ASSET_LINES_V.ASSET_ID%TYPE;
29: l_original_cost OKX_ASSET_LINES_V.ORIGINAL_COST%TYPE;
30: l_deprn_amount NUMBER := 0;
31: l_asset_book_value NUMBER := 0;
32: l_net_book_value NUMBER := 0;

Line 29: l_original_cost OKX_ASSET_LINES_V.ORIGINAL_COST%TYPE;

25: -- this function is used to calculate net book value for a contract
26: FUNCTION calculate_cntrct_nbv (p_cntrct_id IN NUMBER) RETURN NUMBER
27: IS
28: l_asset_id OKX_ASSET_LINES_V.ASSET_ID%TYPE;
29: l_original_cost OKX_ASSET_LINES_V.ORIGINAL_COST%TYPE;
30: l_deprn_amount NUMBER := 0;
31: l_asset_book_value NUMBER := 0;
32: l_net_book_value NUMBER := 0;
33: l_asset_number OKX_ASSET_LINES_V.ASSET_NUMBER%TYPE;

Line 33: l_asset_number OKX_ASSET_LINES_V.ASSET_NUMBER%TYPE;

29: l_original_cost OKX_ASSET_LINES_V.ORIGINAL_COST%TYPE;
30: l_deprn_amount NUMBER := 0;
31: l_asset_book_value NUMBER := 0;
32: l_net_book_value NUMBER := 0;
33: l_asset_number OKX_ASSET_LINES_V.ASSET_NUMBER%TYPE;
34: l_corporate_book OKX_ASSET_LINES_V.CORPORATE_BOOK%TYPE;
35:
36: /* cursor for getting the assets and their original cost */
37: CURSOR okl_cntrct_assets_csr(p_khr_id IN NUMBER) IS

Line 34: l_corporate_book OKX_ASSET_LINES_V.CORPORATE_BOOK%TYPE;

30: l_deprn_amount NUMBER := 0;
31: l_asset_book_value NUMBER := 0;
32: l_net_book_value NUMBER := 0;
33: l_asset_number OKX_ASSET_LINES_V.ASSET_NUMBER%TYPE;
34: l_corporate_book OKX_ASSET_LINES_V.CORPORATE_BOOK%TYPE;
35:
36: /* cursor for getting the assets and their original cost */
37: CURSOR okl_cntrct_assets_csr(p_khr_id IN NUMBER) IS
38: SELECT asset_id, original_cost, asset_number, corporate_book

Line 39: FROM okx_asset_lines_v ast

35:
36: /* cursor for getting the assets and their original cost */
37: CURSOR okl_cntrct_assets_csr(p_khr_id IN NUMBER) IS
38: SELECT asset_id, original_cost, asset_number, corporate_book
39: FROM okx_asset_lines_v ast
40: WHERE ast.dnz_chr_id = p_khr_id;
41:
42: /* cursor to get the depreciation amount */
43: CURSOR depr_csr(p_asset_id NUMBER, p_book_type_code VARCHAR2) IS