DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_MC_IMPAIRMENTS

Line 5159: from fa_mc_impairments

5155: l_period_rec FA_API_TYPES.period_rec_type;
5156:
5157: CURSOR c_mc_check_imp is
5158: select 'POSTED'
5159: from fa_mc_impairments
5160: where status = 'POSTED'
5161: and (asset_id = p_asset_id or cash_generating_unit_id = (select cash_generating_unit_id
5162: from fa_mc_books bk
5163: where bk.asset_id = p_asset_id

Line 5222: delete from fa_mc_impairments

5218: and bk.date_ineffective is null))
5219: and book_type_code = p_book
5220: and period_counter_impaired = l_period_rec.period_counter;
5221:
5222: delete from fa_mc_impairments
5223: where status = 'PREVIEWED'
5224: and (asset_id = p_asset_id
5225: or cash_generating_unit_id = (select cash_generating_unit_id
5226: from fa_books bk