APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_MC_BOOKS

Line 121: from fa_mc_books bks,

117: select bks.rowid,
118: bks.asset_id,
119: bks.deprn_method_code,
120: bks.life_in_months
121: from fa_mc_books bks,
122: fa_methods mt
123: where bks.asset_id = p_asset_hdr_rec.asset_id
124: and bks.book_type_code = p_asset_hdr_rec.book_type_code
125: and bks.transaction_header_id_out is null

Line 506: update fa_mc_books bk

502:
503: if (p_mrc_sob_type_code = 'R') then
504:
505: -- Bug:5701095
506: update fa_mc_books bk
507: set (adjusted_cost, eofy_reserve, formula_factor, adjusted_capacity) =
508: (Select Decode(p_period_rec.period_num - pers_per_yr,
509: 0, decode(bk2.eofy_adj_cost,
510: null, decode(bk2.eop_adj_cost,

Line 545: From fa_mc_deprn_summary ds2, fa_mc_deprn_summary ds1, fa_mc_books bk2

541: bk2.eop_formula_factor)),
542: Decode(bk2.eop_adj_cost,
543: null, bk2.adjusted_capacity,
544: bk2.old_adjusted_capacity)
545: From fa_mc_deprn_summary ds2, fa_mc_deprn_summary ds1, fa_mc_books bk2
546: where bk2.transaction_header_id_in = bk.transaction_header_id_in
547: and bk2.set_of_books_id = p_asset_hdr_rec.set_of_books_id
548: and ds2.asset_id(+) = bk2.asset_id
549: and ds2.book_type_code(+) = bk2.book_type_code

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 1417: delete from fa_mc_books

1413: and book_type_code = p_asset_hdr_rec.book_type_code
1414: and transaction_header_id = g_l_thid
1415: and set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
1416:
1417: delete from fa_mc_books
1418: where asset_id = p_asset_hdr_rec.asset_id
1419: and book_type_code = p_asset_hdr_rec.book_type_code
1420: and transaction_header_id_in = g_l_thid
1421: and set_of_books_id = p_asset_hdr_rec.set_of_books_id ;

Line 1423: update fa_mc_books

1419: and book_type_code = p_asset_hdr_rec.book_type_code
1420: and transaction_header_id_in = g_l_thid
1421: and set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
1422:
1423: update fa_mc_books
1424: set transaction_header_id_out = null,
1425: date_ineffective = null
1426: where asset_id = p_asset_hdr_rec.asset_id
1427: and book_type_code = p_asset_hdr_rec.book_type_code

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,