APPS.OKL_SPLIT_ASSET_PVT dependencies on FA_BOOK_CONTROLS

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

2549: --cursor to fetch the corporate and tax book for the given asset
2550: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
2551: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
2552: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
2553: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
2554: WHERE o.parent_line_id = p_kle_id
2555: AND o.asset_id = a.asset_id
2556: AND a.book_type_code = b.book_type_code
2557: AND a.date_ineffective IS NULL

Line 10768: l_mg_rep_book fa_book_controls.book_type_code%TYPE;

10764: l_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
10765: l_tax_owner Varchar2(150);
10766: l_rep_tax_owner Varchar2(150);
10767: l_Multi_GAAP_YN Varchar2(1);
10768: l_mg_rep_book fa_book_controls.book_type_code%TYPE;
10769: l_amortization_start_date DATE:=NULL;
10770: -- CURSOR TO GET MAX OFF LEASE TRX DATESELECT
10771: Cursor tax_off_trx_amt(p_asset_id in number, p_tax_book in varchar2) is
10772: select tas.date_trans_occurred