DBA Data[Home] [Help]

APPS.FA_REVALUATION_PVT dependencies on FA_MC_DEPRN_SUMMARY

Line 404: INSERT INTO FA_MC_DEPRN_SUMMARY(SET_OF_BOOKS_ID

400: , nvl(l_dpr_row.deprn_exp, 0) -- DEPRN_ADJUSTMENT_AMOUNT
401: , NVL(l_asset_deprn_rec_new.reval_loss_balance,0) -- REVAL_LOSS_BALANCE
402: );
403: else
404: INSERT INTO FA_MC_DEPRN_SUMMARY(SET_OF_BOOKS_ID
405: , BOOK_TYPE_CODE
406: , ASSET_ID
407: , PERIOD_COUNTER
408: , DEPRN_RUN_DATE

Line 3092: update fa_mc_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost

3088: where asset_id = p_asset_hdr_rec.asset_id
3089: and book_type_code = p_asset_hdr_rec.book_type_code
3090: and period_counter = l_adj_in.period_counter_adjusted - 1;
3091: ELSE
3092: update fa_mc_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost
3093: where asset_id = p_asset_hdr_rec.asset_id
3094: and book_type_code = p_asset_hdr_rec.book_type_code
3095: and set_of_books_id = p_asset_hdr_rec.set_of_books_id
3096: and period_counter = l_adj_in.period_counter_adjusted - 1;

Line 3544: update fa_mc_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost

3540: where asset_id = p_asset_hdr_rec.asset_id
3541: and book_type_code = p_asset_hdr_rec.book_type_code
3542: and period_counter = l_adj_in.period_counter_adjusted - 1;
3543: ELSE
3544: update fa_mc_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost
3545: where asset_id = p_asset_hdr_rec.asset_id
3546: and book_type_code = p_asset_hdr_rec.book_type_code
3547: and set_of_books_id = p_asset_hdr_rec.set_of_books_id
3548: and period_counter = l_adj_in.period_counter_adjusted - 1;