243: bk.period_counter_fully_reserved,
244: bk.period_counter_fully_retired,
245: bk.cash_generating_unit_id
246: from fa_adjustments_t ajitf,
247: fa_books bk,
248: fa_additions_b ad
249: where ajitf.book_type_code = p_book_type_code
250: and ajitf.posting_status = 'POST'
251: and ajitf.asset_number = ad.asset_number
266: cursor check_exp_amort (p_asset_id in number,
267: p_book in varchar2) is
268: select count(*)
269: into l_amort_count
270: from fa_books bk
271: where bk.book_type_code = p_book
272: and bk.asset_id = p_asset_id
273: and (bk.rate_Adjustment_factor <> 1 OR
274: (bk.rate_adjustment_factor = 1 and