APPS.FA_SORP_REVALUATION_PKG dependencies on FA_BOOKS

Line 59: fa_books

55: book_type_code=p_book_type_code;
56:
57: CURSOR c_get_old_fin_rec is
58: select * from
59: fa_books
60: where book_type_code = p_book_type_code and
61: asset_id = p_asset_id and
62: transaction_header_id_out = (select transaction_header_id
63: from

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

Line 2329: FROM FA_BOOKS

2325: SELECT book_type_code,asset_id,recoverable_cost,salvage_value,adjusted_recoverable_cost,adjusted_cost,old_adjusted_cost,
2326: formula_factor,rate_Adjustment_factor,eofy_reserve,deprn_method_code,life_in_months,adjusted_rate,production_capacity,
2327: adjusted_capacity,bonus_rule,ceiling_name,reval_amortization_basis,date_placed_in_service,prorate_date,original_deprn_start_date,
2328: tracking_method,period_counter_life_complete,annual_deprn_rounding_flag
2329: FROM FA_BOOKS
2330: WHERE TRANSACTION_HEADER_ID_OUT = p_th_id;
2331:
2332: CURSOR c_mc_get_pr_asset_rec Is
2333: SELECT book_type_code,asset_id,recoverable_cost,salvage_value,adjusted_recoverable_cost,adjusted_cost,old_adjusted_cost,

Line 2346: FROM FA_BOOKS

2342: SELECT book_type_code,asset_id,recoverable_cost,salvage_value,adjusted_recoverable_cost,adjusted_cost,old_adjusted_cost,
2343: formula_factor,rate_Adjustment_factor,eofy_reserve,deprn_method_code,life_in_months,adjusted_rate,production_capacity,
2344: adjusted_capacity,bonus_rule,ceiling_name,reval_amortization_basis,date_placed_in_service,prorate_date,ORIGINAL_DEPRN_START_DATE,
2345: tracking_method,period_counter_life_complete,annual_deprn_rounding_flag
2346: FROM FA_BOOKS
2347: WHERE TRANSACTION_HEADER_ID_IN = p_th_id;
2348:
2349: CURSOR c_mc_get_asset_rec Is
2350: SELECT book_type_code,asset_id,recoverable_cost,salvage_value,adjusted_recoverable_cost,adjusted_cost,old_adjusted_cost,