DBA Data[Home] [Help]

APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_ADJUSTMENTS

Line 641: --To fetch depreciation expense from fa_adjustments for the transfer transaction (keep)

637: FROM igi_iac_fa_deprn iadb
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

Line 745: -- l_historic_deprn_expense will be calculated from fa_adjustments

741: l_asset_rec.dep_expense_catchup := 0;
742: l_asset_rec.op_expense_catchup := 0;
743: IF g_prior_period THEN
744: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data ');
745: -- l_historic_deprn_expense will be calculated from fa_adjustments
746: -- OPEN c_get_deprn_expense (p_trans_rec.transaction_header_id);
747: OPEN c_get_deprn_expense(p_curr_prd_cntr - 1);
748: FETCH c_get_deprn_expense INTO l_historic_deprn_expense;
749:

Line 1068: FROM FA_ADJUSTMENTS adj,

1064: p_distribution_id number,
1065: p_transaction_header_id number)
1066: IS
1067: SELECT count(*) interco_count
1068: FROM FA_ADJUSTMENTS adj,
1069: FA_BOOK_CONTROLS bc
1070: WHERE adj.book_type_code = p_book_type_code
1071: AND adj.ASSET_ID = p_asset_id
1072: AND adj.SOURCE_TYPE_CODE = 'TRANSFER'