DBA Data[Home] [Help]

APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_DEPRN_DETAIL

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

568: WHERE iadb.adjustment_id = cp_adjustment_id
569: AND iadb.active_flag IS NULL;
570:
571: --To fetch depreciation expense from fa_adjustments for the transfer transaction (keep)
572: CURSOR c_get_deprn_expense(cp_period_counter fa_deprn_detail.period_counter%TYPE)
573: IS
574: SELECT sum(deprn_amount-deprn_adjustment_amount ) deprn_amount
575: FROM fa_deprn_detail
576: WHERE book_type_code = p_book_type_code

Line 575: FROM fa_deprn_detail

571: --To fetch depreciation expense from fa_adjustments for the transfer transaction (keep)
572: CURSOR c_get_deprn_expense(cp_period_counter fa_deprn_detail.period_counter%TYPE)
573: IS
574: SELECT sum(deprn_amount-deprn_adjustment_amount ) deprn_amount
575: FROM fa_deprn_detail
576: WHERE book_type_code = p_book_type_code
577: AND period_counter = cp_period_counter
578: AND asset_id = p_asset_id;
579: