DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_IMPAIRMENTS

Line 5172: from fa_impairments

5168: AND set_of_books_id = p_set_of_books_id;
5169:
5170: CURSOR c_check_imp is
5171: select 'POSTED'
5172: from fa_impairments
5173: where status = 'POSTED'
5174: and (asset_id = p_asset_id or cash_generating_unit_id = (select cash_generating_unit_id
5175: from fa_books bk
5176: where bk.asset_id = p_asset_id

Line 5210: update fa_impairments

5206: p_log_level_rec => p_log_level_rec);
5207: return false;
5208: end if;
5209: /*Bug#8436466 */
5210: update fa_impairments
5211: set status = 'NEW'
5212: where status = 'PREVIEWED'
5213: and (asset_id = p_asset_id
5214: or cash_generating_unit_id = (select cash_generating_unit_id