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
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