APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on FA_ADDITIONS

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

485: AND adjustment_id =p_prev_adjustment_id
486: AND distribution_id = P_distribution_id;
487:
488: /* Cursor to get total units assigned for the Asset from FA */
489: CURSOR c_get_fa_asset(p_asset_id fa_additions.asset_id%TYPE) IS
490: SELECT asset_category_id,current_units
491: FROM fa_additions
492: WHERE asset_id = p_asset_id;
493:

Line 491: FROM fa_additions

487:
488: /* Cursor to get total units assigned for the Asset from FA */
489: CURSOR c_get_fa_asset(p_asset_id fa_additions.asset_id%TYPE) IS
490: SELECT asset_category_id,current_units
491: FROM fa_additions
492: WHERE asset_id = p_asset_id;
493:
494: CURSOR c_get_active_det_balances (cp_book_type_code in varchar2
495: , cp_asset_id in number

Line 518: l_category_id fa_additions.asset_category_id%TYPE;

514: l_get_iac_fa_deprn C_get_iac_fa_deprn%ROWTYPE;
515: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
516: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
517: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
518: l_category_id fa_additions.asset_category_id%TYPE;
519: l_asset_units fa_additions.current_units%TYPE;
520: l_distribution_units fa_distribution_history.units_assigned%TYPE;
521: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
522: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

Line 519: l_asset_units fa_additions.current_units%TYPE;

515: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
516: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
517: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
518: l_category_id fa_additions.asset_category_id%TYPE;
519: l_asset_units fa_additions.current_units%TYPE;
520: l_distribution_units fa_distribution_history.units_assigned%TYPE;
521: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
522: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
523: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;