638: WHERE iadb.adjustment_id = cp_adjustment_id
639: AND iadb.active_flag IS NULL;
640:
641: --To fetch depreciation expense from fa_adjustments for the transfer transaction (keep)
642: CURSOR c_get_deprn_expense(cp_period_counter fa_deprn_detail.period_counter%TYPE)
643: IS
644: SELECT sum(deprn_amount-deprn_adjustment_amount ) deprn_amount
645: FROM fa_deprn_detail
646: WHERE book_type_code = p_book_type_code
641: --To fetch depreciation expense from fa_adjustments for the transfer transaction (keep)
642: CURSOR c_get_deprn_expense(cp_period_counter fa_deprn_detail.period_counter%TYPE)
643: IS
644: SELECT sum(deprn_amount-deprn_adjustment_amount ) deprn_amount
645: FROM fa_deprn_detail
646: WHERE book_type_code = p_book_type_code
647: AND period_counter = cp_period_counter
648: AND asset_id = p_asset_id;
649: