DBA Data[Home] [Help]

APPS.FA_SORP_UPG_PKG dependencies on FA_MC_ADJUSTMENTS

Line 492: from fa_mc_adjustments

488: l_old_dist_gf := 0;
489: BEGIN
490: select NVL(SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',-1 * ADJUSTMENT_AMOUNT,ADJUSTMENT_AMOUNT)),0)
491: into l_reval_reserve_ca
492: from fa_mc_adjustments
493: where asset_id = p_asset_id
494: and distribution_id = nvl(p_dist_id,distribution_id)
495: and period_counter_created = p_period_counter
496: and book_type_code = p_book_type_code

Line 511: from fa_mc_adjustments

507:
508: BEGIN
509: select NVL(SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',ADJUSTMENT_AMOUNT,-1 * ADJUSTMENT_AMOUNT)),0)
510: into l_nbv_retired_ca
511: from fa_mc_adjustments
512: where asset_id = p_asset_id
513: and distribution_id = nvl(p_dist_id,distribution_id)
514: and period_counter_created = p_period_counter
515: and book_type_code = p_book_type_code