APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 500: FROM fa_distribution_history fdh,

496: , cp_adjustment_id in number
497: ) is
498: SELECT fdh.units_assigned,
499: idb.*
500: FROM fa_distribution_history fdh,
501: igi_iac_det_balances idb
502: WHERE fdh.book_type_code = cp_book_type_code
503: AND fdh.asset_id = cp_asset_id
504: AND fdh.date_ineffective IS NULL

Line 520: l_distribution_units fa_distribution_history.units_assigned%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;
524: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;