DBA Data[Home] [Help]

APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_MC_BOOKS_SUMMARY

Line 710: delete from fa_mc_books_summary bs

706: end if;
707:
708: if (p_mrc_sob_type_code = 'R') then
709:
710: delete from fa_mc_books_summary bs
711: where bs.asset_id = p_asset_hdr_rec.asset_id
712: and bs.book_type_code = p_asset_hdr_rec.book_type_code
713: and bs.period_counter = p_period_rec.period_counter + 1
714: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;

Line 716: update fa_mc_books_summary bs

712: and bs.book_type_code = p_asset_hdr_rec.book_type_code
713: and bs.period_counter = p_period_rec.period_counter + 1
714: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
715:
716: update fa_mc_books_summary bs
717: set deprn_amount = expense_adjustment_amount,
718: ytd_deprn = ytd_deprn - nvl(deprn_amount,0) + nvl(expense_adjustment_amount,0), --Bug8244128
719: deprn_reserve = deprn_reserve - nvl(deprn_amount,0) + nvl(expense_adjustment_amount,0), --Bug8244128
720: bonus_deprn_amount = 0,

Line 1451: update fa_mc_books_summary

1447: where book_type_code = p_asset_hdr_rec.book_type_code
1448: and asset_id = p_asset_hdr_rec.asset_id
1449: and period_counter = p_period_rec.period_counter;
1450: else
1451: update fa_mc_books_summary
1452: set terminal_gain_loss_flag = 'Y',
1453: terminal_gain_loss_amount = null,
1454: reserve_adjustment_amount = reserve_adjustment_amount - terminal_gain_loss_amount,
1455: deprn_reserve = deprn_reserve - terminal_gain_loss_amount,