758: l_txn_status boolean := FALSE;
759:
760: cursor ck_asset_retired is
761: select nvl(b.period_counter_fully_retired,0) 762: from fa_books b 763: where b.asset_id = p_from_asset_id
764: and b.date_ineffective is null
765: and b.book_type_code = p_book_type_code;
766: