167: , book_type_code
168: , add_months(prorate_date, life_in_months) life_end_date
169: , life_in_months
170: , 'CORPORATE' book_class
171: from fa_books
172: where asset_id = x_asset_id
173: and date_ineffective IS NULL
174: and nvl(x_rule_det_rec.include_asset_end_date_flag, 'N') = 'Y'
175: and book_type_code = x_book_type_code
446: , nvl(x_prorate_date,prorate_date) -- Use Asset Pro Rate date if nothing passed
447: , deprn_method_code
448: , prorate_convention_code
449: , life_in_months
450: from fa_books
451: where asset_id = x_asset_id
452: and book_type_code = x_book_type_code
453: and date_ineffective IS NULL;
454: