APPS.OKL_AM_AMORTIZE_PVT dependencies on FA_ADDITIONS_B

Line 8: depreciation_category fa_additions_b.asset_category_id%TYPE,

4: -- SECHAWLA 06-MAY-04 3578894 : Added a new type declaration
5: TYPE book_rec_type IS RECORD
6: ( parent_line_id NUMBER,
7: dnz_chr_id NUMBER,
8: depreciation_category fa_additions_b.asset_category_id%TYPE,
9: book_type_code FA_BOOKS.book_type_code%TYPE,
10: book_class FA_BOOK_CONTROLS.book_class%TYPE,
11: salvage_value FA_BOOKS.salvage_value%TYPE,
12: DEPRN_METHOD_CODE FA_BOOKS.DEPRN_METHOD_CODE%TYPE ,

Line 16: asset_number fa_additions_b.asset_number%TYPE,

12: DEPRN_METHOD_CODE FA_BOOKS.DEPRN_METHOD_CODE%TYPE ,
13: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
14: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
15: DEPRN_RATE NUMBER,
16: asset_number fa_additions_b.asset_number%TYPE,
17: item_description okc_k_lines_tl.item_description%TYPE,
18: asset_id fa_books.asset_id%TYPE,
19: original_cost fa_books.original_cost%TYPE,
20: current_units fa_additions_b.current_units%TYPE,

Line 20: current_units fa_additions_b.current_units%TYPE,

16: asset_number fa_additions_b.asset_number%TYPE,
17: item_description okc_k_lines_tl.item_description%TYPE,
18: asset_id fa_books.asset_id%TYPE,
19: original_cost fa_books.original_cost%TYPE,
20: current_units fa_additions_b.current_units%TYPE,
21: in_service_date fa_books.DATE_PLACED_IN_SERVICE%TYPE);
22:
23:
24:

Line 3495: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc

3491: -- SECHAWLA 06-MAY-04 3578894 : added cp_sysdate parameter
3492: -- get all the tax books and validate that mg rep book (set in profile) is one of the asset tax books
3493: CURSOR l_fataxbooks_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
3494: SELECT fb.book_type_code
3495: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
3496: WHERE fb.asset_id = fab.asset_id
3497: AND fb.book_type_code = fbc.book_type_code
3498: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate
3499: AND fb.transaction_header_id_out IS NULL

Line 3507: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc

3503: -- SECHAWLA 06-MAY-04 3578894 : added cp_sysdate parameter
3504: --Get the asset corporate book
3505: CURSOR l_facorpbook_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
3506: SELECT fb.book_type_code
3507: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
3508: WHERE fb.asset_id = fab.asset_id
3509: AND fb.book_type_code = fbc.book_type_code
3510: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate
3511: AND fb.transaction_header_id_out IS NULL

Line 3547: fa_additions_b fab,

3543: fb.original_cost,
3544: fab.current_units,
3545: fb.DATE_PLACED_IN_SERVICE in_service_date
3546: FROM fa_books fb,
3547: fa_additions_b fab,
3548: fa_book_controls fbc,
3549: okc_k_items cim_fa,
3550: okc_k_lines_b cleb_fa,
3551: okc_line_styles_b lseb_fa,

Line 3596: fa_additions_b fab,

3592: fb.original_cost,
3593: fab.current_units,
3594: fb.DATE_PLACED_IN_SERVICE in_service_date
3595: FROM fa_books fb,
3596: fa_additions_b fab,
3597: fa_book_controls fbc,
3598: okc_k_items cim_fa,
3599: okc_k_lines_b cleb_fa,
3600: okc_line_styles_b lseb_fa,

Line 3646: fa_additions_b fab,

3642: fb.original_cost,
3643: fab.current_units,
3644: fb.DATE_PLACED_IN_SERVICE in_service_date
3645: FROM fa_books fb,
3646: fa_additions_b fab,
3647: fa_book_controls fbc,
3648: okc_k_items cim_fa,
3649: okc_k_lines_b cleb_fa,
3650: okc_line_styles_b lseb_fa,

Line 3696: fa_additions_b fab,

3692: fb.original_cost,
3693: fab.current_units,
3694: fb.DATE_PLACED_IN_SERVICE in_service_date
3695: FROM fa_books fb,
3696: fa_additions_b fab,
3697: fa_book_controls fbc,
3698: okc_k_items cim_fa,
3699: okc_k_lines_b cleb_fa,
3700: okc_line_styles_b lseb_fa,