APPS.IGI_IAC_DEPRN_PKG dependencies on FA_ADDITIONS

Line 135: FROM fa_books bk, fa_additions ad

131: ) return BOOLEAN IS
132:
133: CURSOR c_get_non_deprn_assets IS
134: SELECT bk.asset_id, ad.asset_category_id
135: FROM fa_books bk, fa_additions ad
136: WHERE bk.book_type_code = p_book_type_code
137: AND bk.transaction_header_id_out IS NULL
138: AND bk.depreciate_flag = 'NO'
139: AND bk.adjustment_required_status = 'ADD'

Line 262: CURSOR c_get_fa_asset(p_asset_id fa_additions.asset_id%TYPE) IS

258: AND book_type_code = p_book_type_code
259: AND period_counter = p_period_counter ;
260:
261: /* Cursor to get total units assigned for the Asset from FA */
262: CURSOR c_get_fa_asset(p_asset_id fa_additions.asset_id%TYPE) IS
263: SELECT asset_category_id,current_units
264: FROM fa_additions
265: WHERE asset_id = p_asset_id;
266:

Line 264: FROM fa_additions

260:
261: /* Cursor to get total units assigned for the Asset from FA */
262: CURSOR c_get_fa_asset(p_asset_id fa_additions.asset_id%TYPE) IS
263: SELECT asset_category_id,current_units
264: FROM fa_additions
265: WHERE asset_id = p_asset_id;
266:
267: /* Cursor to get balance information for each distribution of asset */
268: CURSOR c_get_detail_balance(p_asset_id igi_iac_det_balances.asset_id%TYPE

Line 334: l_category_id fa_additions.asset_category_id%TYPE;

330: l_detail_balance igi_iac_det_balances%ROWTYPE;
331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
334: l_category_id fa_additions.asset_category_id%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;

Line 335: l_asset_units fa_additions.current_units%TYPE;

331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
334: l_category_id fa_additions.asset_category_id%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;