APPS.FA_IMPAIRMENT_PREV_PVT dependencies on FA_MC_IMPAIRMENTS

Line 1264: from fa_mc_impairments imp

1260: , imp.asset_id -- Bug# 7000391
1261: , nvl(books.sorp_enabled_flag, 'N') -- Bug 6666666
1262: , imp.net_selling_price --Bug# 7511258
1263: , imp.value_in_use --Bug# 7511258
1264: from fa_mc_impairments imp
1265: , fa_mc_itf_impairments itf
1266: , fa_book_controls books
1267: where imp.request_id = p_request_id
1268: and imp.book_type_code = p_book_type_code

Line 1344: from fa_mc_impairments

1340: --Bug# 7594562 - To check if any impairment is already posted in current period for an asset
1341: --Bug# 14595406 - Modified query
1342: CURSOR c_mc_check_imp(c_asset_id number,c_cgu_id number) is
1343: select 'POSTED'
1344: from fa_mc_impairments
1345: where status = 'POSTED'
1346: and ((asset_id = c_asset_id or cash_generating_unit_id = c_cgu_id) or
1347: (asset_id in (select asset_id from fa_books fbs
1348: where fbs.book_type_code = p_book_type_code

Line 1462: UPDATE FA_MC_IMPAIRMENTS IMP

1458: end if;
1459:
1460: if (p_mrc_sob_type_code = 'R') then
1461: FORALL i in 1..t_impairment_id.count
1462: UPDATE FA_MC_IMPAIRMENTS IMP
1463: SET NET_BOOK_VALUE = t_net_book_value(i)
1464: , IMPAIRMENT_AMOUNT = round(decode(nvl(t2_impairment_amount(i), 0), 0,
1465: t_net_book_value(i) - t_fair_market_value(i), t2_impairment_amount(i)),l_precision)
1466: , IMPAIRMENT_DATE = nvl(IMPAIRMENT_DATE, p_transaction_date)

Line 1757: UPDATE FA_MC_IMPAIRMENTS IMP

1753:
1754:
1755: if p_mrc_sob_type_code = 'R' then
1756: FORALL i in 1..t_impairment_id.count
1757: UPDATE FA_MC_IMPAIRMENTS IMP
1758: SET NET_BOOK_VALUE = t_net_book_value(i)
1759: WHERE ROWID = t_rowid(i);
1760: else
1761: FORALL i in 1..t_impairment_id.count