APPS.OKL_SPLIT_ASSET_PVT dependencies on FA_BOOK_CONTROLS

Line 2525: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

2521: --cursor to fetch the corporate and tax book for the given asset
2522: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
2523: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
2524: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
2525: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
2526: WHERE o.parent_line_id = p_kle_id
2527: AND o.asset_id = a.asset_id
2528: AND a.book_type_code = b.book_type_code
2529: AND a.date_ineffective IS NULL

Line 10715: l_mg_rep_book fa_book_controls.book_type_code%TYPE;

10711: l_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
10712: l_tax_owner Varchar2(150);
10713: l_rep_tax_owner Varchar2(150);
10714: l_Multi_GAAP_YN Varchar2(1);
10715: l_mg_rep_book fa_book_controls.book_type_code%TYPE;
10716: l_amortization_start_date DATE:=NULL;
10717: -- CURSOR TO GET MAX OFF LEASE TRX DATESELECT
10718: Cursor tax_off_trx_amt(p_asset_id in number, p_tax_book in varchar2) is
10719: select tas.date_trans_occurred