APPS.IGI_IAC_DEPRN_PKG dependencies on FA_DEPRN_DETAIL

Line 195: CURSOR c_get_deprn_amount(p_asset_id fa_deprn_detail.asset_id%TYPE) IS

191: WHERE book_type_code = p_book_type_code
192: AND period_counter = p_period_counter ;
193:
194: /* Cursor to get the depreciation amount for the period for the asset */
195: CURSOR c_get_deprn_amount(p_asset_id fa_deprn_detail.asset_id%TYPE) IS
196: SELECT sum(nvl(deprn_amount,0)), sum(nvl(deprn_adjustment_amount,0))
197: FROM fa_deprn_detail
198: WHERE book_type_code = p_book_type_code
199: AND period_counter = p_period_counter

Line 197: FROM fa_deprn_detail

193:
194: /* Cursor to get the depreciation amount for the period for the asset */
195: CURSOR c_get_deprn_amount(p_asset_id fa_deprn_detail.asset_id%TYPE) IS
196: SELECT sum(nvl(deprn_amount,0)), sum(nvl(deprn_adjustment_amount,0))
197: FROM fa_deprn_detail
198: WHERE book_type_code = p_book_type_code
199: AND period_counter = p_period_counter
200: AND asset_id = p_asset_id;
201:

Line 203: CURSOR c_get_dist_deprn_amount(p_asset_id fa_deprn_detail.asset_id%TYPE,cp_distribution_id fa_deprn_detail.distribution_id%TYPE) IS

199: AND period_counter = p_period_counter
200: AND asset_id = p_asset_id;
201:
202: /* Cursor to get the depreciation amount for the period for the asset */
203: CURSOR c_get_dist_deprn_amount(p_asset_id fa_deprn_detail.asset_id%TYPE,cp_distribution_id fa_deprn_detail.distribution_id%TYPE) IS
204: SELECT nvl(deprn_amount,0) deprn_amount, nvl(deprn_adjustment_amount,0) deprn_adjustment_amount, nvl(deprn_reserve,0) deprn_reserve
205: FROM fa_deprn_detail
206: WHERE book_type_code = p_book_type_code
207: AND period_counter = p_period_counter

Line 205: FROM fa_deprn_detail

201:
202: /* Cursor to get the depreciation amount for the period for the asset */
203: CURSOR c_get_dist_deprn_amount(p_asset_id fa_deprn_detail.asset_id%TYPE,cp_distribution_id fa_deprn_detail.distribution_id%TYPE) IS
204: SELECT nvl(deprn_amount,0) deprn_amount, nvl(deprn_adjustment_amount,0) deprn_adjustment_amount, nvl(deprn_reserve,0) deprn_reserve
205: FROM fa_deprn_detail
206: WHERE book_type_code = p_book_type_code
207: AND period_counter = p_period_counter
208: AND asset_id = p_asset_id
209: AND distribution_id = cp_distribution_id;

Line 339: l_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;

335: l_asset_units fa_additions.current_units%TYPE;
336: l_distribution_units fa_distribution_history.units_assigned%TYPE;
337: l_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE ;
338: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
339: l_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
340: l_reval_reserve igi_iac_asset_balances.reval_reserve%TYPE;
341: l_general_fund igi_iac_asset_balances.general_fund%TYPE;
342: l_reval_rsv_net igi_iac_det_balances.reval_reserve_net%TYPE;
343: l_reval_rsv_gen_fund igi_iac_det_balances.reval_reserve_gen_fund%TYPE;