DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 529: FROM fa_distribution_history fdh,

525: , cp_adjustment_id in number
526: ) is
527: SELECT fdh.units_assigned,
528: idb.*
529: FROM fa_distribution_history fdh,
530: igi_iac_det_balances idb
531: WHERE fdh.book_type_code = cp_book_type_code
532: AND fdh.asset_id = cp_asset_id
533: AND fdh.date_ineffective IS NULL

Line 549: l_distribution_units fa_distribution_history.units_assigned%TYPE;

545: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
546: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
547: l_category_id fa_additions.asset_category_id%TYPE;
548: l_asset_units fa_additions.current_units%TYPE;
549: l_distribution_units fa_distribution_history.units_assigned%TYPE;
550: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
551: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
552: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
553: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;