APPS.OKL_AM_AMORTIZE_PVT dependencies on FA_BOOK_CONTROLS

Line 10: book_class FA_BOOK_CONTROLS.book_class%TYPE,

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 ,
13: LIFE_IN_MONTHS FA_BOOKS.LIFE_IN_MONTHS%TYPE,
14: -- SECHAWLA 28-MAY-04 3645574 : Added deprn_rate

Line 64: l_mg_rep_book fa_book_controls.book_type_code%TYPE;

60: lp_empty_pdtv_rec pdtv_rec_type;
61: lx_no_data_found BOOLEAN;
62: lx_pdt_parameter_rec pdt_parameters_rec_type ;
63: l_contract_number VARCHAR2(120);
64: l_mg_rep_book fa_book_controls.book_type_code%TYPE;
65: mg_error EXCEPTION;
66: l_reporting_product OKL_PRODUCTS_V.NAME%TYPE;
67: l_reporting_product_id NUMBER;
68: l_rep_deal_type okl_product_parameters_v.deal_type%TYPE;

Line 3484: lx_mg_rep_book fa_book_controls.book_type_code%TYPE;

3480: l_contract_id NUMBER;
3481: l_contract_number VARCHAR2(120);
3482:
3483: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
3484: lx_mg_rep_book fa_book_controls.book_type_code%TYPE;
3485: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
3486:
3487: l_rep_book_found VARCHAR2(1) := 'N';
3488:

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 3548: fa_book_controls fbc,

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,
3552: okc_k_lines_tl clet_fin,

Line 3597: fa_book_controls fbc,

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,
3601: okc_k_lines_tl clet_fin,

Line 3647: fa_book_controls fbc,

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,
3651: okc_k_lines_tl clet_fin,

Line 3697: fa_book_controls fbc,

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,
3701: okc_k_lines_tl clet_fin,