APPS.FA_SORP_REVALUATION_PKG dependencies on FA_MC_BOOKS_SUMMARY

Line 2051: fa_mc_books_summary fbs,

2047: adj.period_counter_created,
2048: fbs.reval_loss_balance
2049: FROM
2050: FA_MC_ADJUSTMENTS adj,
2051: fa_mc_books_summary fbs,
2052: fa_transaction_headers fth
2053: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2054: AND adj.book_type_code = p_asset_hdr_rec.book_type_code
2055: AND adj.adjustment_type in ('REVAL LOSS','REVAL RESERVE')

Line 2279: update fa_mc_books_summary set reval_loss_balance = reval_loss_balance - (l_net_reval_loss + l_deprn_exp)

2275: where asset_id = p_asset_hdr_rec.asset_id
2276: and book_type_code = p_asset_hdr_rec.book_type_code
2277: and period_counter >= c_loss_period_counter ;
2278: ELSE
2279: update fa_mc_books_summary set reval_loss_balance = reval_loss_balance - (l_net_reval_loss + l_deprn_exp)
2280: where asset_id = p_asset_hdr_rec.asset_id
2281: and book_type_code = p_asset_hdr_rec.book_type_code
2282: and set_of_books_id = p_set_of_books_id
2283: and period_counter >= c_loss_period_counter ;