APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_BOOKS_SUMMARY_MRC_V

Line 609: delete from fa_books_summary_mrc_v bs

605: end if;
606:
607: if (p_mrc_sob_type_code = 'R') then
608:
609: delete from fa_books_summary_mrc_v bs
610: where bs.asset_id = p_asset_hdr_rec.asset_id
611: and bs.book_type_code = p_asset_hdr_rec.book_type_code
612: and bs.period_counter = p_period_rec.period_counter + 1;
613:

Line 614: update fa_books_summary_mrc_v bs

610: where bs.asset_id = p_asset_hdr_rec.asset_id
611: and bs.book_type_code = p_asset_hdr_rec.book_type_code
612: and bs.period_counter = p_period_rec.period_counter + 1;
613:
614: update fa_books_summary_mrc_v bs
615: set deprn_amount = expense_adjustment_amount,
616: ytd_deprn = ytd_deprn - deprn_amount + expense_adjustment_amount,
617: deprn_reserve = deprn_reserve - deprn_amount + expense_adjustment_amount,
618: bonus_deprn_amount = 0,

Line 1229: update fa_books_summary_mrc_v

1225: where book_type_code = p_asset_hdr_rec.book_type_code
1226: and asset_id = p_asset_hdr_rec.asset_id
1227: and period_counter = p_period_rec.period_counter;
1228: else
1229: update fa_books_summary_mrc_v
1230: set terminal_gain_loss_flag = 'Y',
1231: terminal_gain_loss_amount = null,
1232: reserve_adjustment_amount = reserve_adjustment_amount - terminal_gain_loss_amount,
1233: deprn_reserve = deprn_reserve - terminal_gain_loss_amount,