APPS.FA_REVALUATION_PVT dependencies on FA_DEPRN_SUMMARY

Line 329: INSERT INTO FA_DEPRN_SUMMARY( BOOK_TYPE_CODE

325: l_general_fund := 0;
326: end if;
327:
328: IF (p_mrc_sob_type_code <> 'R') then
329: INSERT INTO FA_DEPRN_SUMMARY( BOOK_TYPE_CODE
330: , ASSET_ID
331: , PERIOD_COUNTER
332: , DEPRN_RUN_DATE
333: , DEPRN_AMOUNT

Line 3087: update fa_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost

3083: /*Bug#12571702 - If in period of addition need to updated adj_cost in deprn_summary,
3084: this is to calculated adj_cost correctly when auto-deprn rollback happens*/
3085: IF p_asset_hdr_rec.period_of_addition = 'Y' THEN
3086: IF p_mrc_sob_type_code = 'P' THEN
3087: update fa_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

Line 3539: update fa_deprn_summary set adjusted_cost = px_asset_fin_rec_new.adjusted_cost

3535: /*Bug#12571702 - If in period of addition need to updated adj_cost in deprn_summary,
3536: this is to calculated adj_cost correctly when auto-deprn rollback happens*/
3537: IF p_asset_hdr_rec.period_of_addition = 'Y' THEN
3538: IF p_mrc_sob_type_code = 'P' THEN
3539: update fa_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