297: --Bug8350248
298: CURSOR c_extend_get_original_adjcost(p_asset_id number,
299: p_book_type_code varchar2) is
300: select bk_old.adjusted_cost
301: from fa_books bk_old
302: , fa_books bk_extnd
303: where bk_old.book_type_code = p_book_type_code
304: and bk_old.asset_id = p_asset_id
305: and bk_old.extended_depreciation_period is null
298: CURSOR c_extend_get_original_adjcost(p_asset_id number,
299: p_book_type_code varchar2) is
300: select bk_old.adjusted_cost
301: from fa_books bk_old
302: , fa_books bk_extnd
303: where bk_old.book_type_code = p_book_type_code
304: and bk_old.asset_id = p_asset_id
305: and bk_old.extended_depreciation_period is null
306: and bk_extnd.book_type_code = p_book_type_code