DBA Data[Home] [Help]

APPS.FA_SORP_REVALUATION_PKG dependencies on FA_BOOKS_SUMMARY

Line 2022: fa_books_summary fbs,

2018: adj.period_counter_created,
2019: fbs.reval_loss_balance
2020: FROM
2021: FA_ADJUSTMENTS adj,
2022: fa_books_summary fbs,
2023: fa_transaction_headers fth
2024: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2025: AND adj.book_type_code = p_asset_hdr_rec.book_type_code
2026: AND adj.adjustment_type in ('REVAL LOSS','REVAL RESERVE')

Line 2274: update fa_books_summary set reval_loss_balance = reval_loss_balance - (l_net_reval_loss + l_deprn_exp)

2270: END IF;
2271:
2272: IF (p_reval_options_rec.run_mode = 'RUN') THEN
2273: IF p_mrc_sob_type_code = 'P' THEN
2274: update fa_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