DBA Data[Home] [Help]

APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_DEPRN_DETAIL

Line 642: CURSOR c_get_deprn_expense(cp_period_counter fa_deprn_detail.period_counter%TYPE)

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

Line 645: FROM fa_deprn_detail

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: