DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 129: igi_iac_transaction_headers ith

125: AND irr.book_type_code = p_asset_iac_adj_info.book_type_code
126: AND irr.latest_record = 'Y'
127: AND irr.revaluation_id = (SELECT max(iar.revaluation_id)
128: FROM igi_iac_revaluation_rates iar ,
129: igi_iac_transaction_headers ith
130: WHERE iar.asset_id = p_asset_iac_adj_info.asset_id
131: AND iar.book_type_code = p_asset_iac_adj_info.book_type_code
132: AND ith.book_type_code = p_asset_iac_adj_info.book_type_code
133: AND ith.asset_id = p_asset_iac_adj_info.asset_id

Line 550: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%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;
554: l_backlog Number;

Line 551: l_Transaction_Id igi_iac_transaction_headers.transaction_header_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;
554: l_backlog Number;
555: l_rowid ROWID;

Line 552: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_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;
554: l_backlog Number;
555: l_rowid ROWID;
556: l_sob_id number;

Line 553: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%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;
554: l_backlog Number;
555: l_rowid ROWID;
556: l_sob_id number;
557: l_coa_id number;