DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 106: igi_iac_transaction_headers ith

102: AND irr.book_type_code = p_asset_iac_adj_info.book_type_code
103: AND irr.latest_record = 'Y'
104: AND irr.revaluation_id = (SELECT max(iar.revaluation_id)
105: FROM igi_iac_revaluation_rates iar ,
106: igi_iac_transaction_headers ith
107: WHERE iar.asset_id = p_asset_iac_adj_info.asset_id
108: AND iar.book_type_code = p_asset_iac_adj_info.book_type_code
109: AND ith.book_type_code = p_asset_iac_adj_info.book_type_code
110: AND ith.asset_id = p_asset_iac_adj_info.asset_id

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

Line 522: l_Transaction_Id igi_iac_transaction_headers.transaction_header_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;
525: l_backlog Number;
526: l_rowid ROWID;

Line 523: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_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;
525: l_backlog Number;
526: l_rowid ROWID;
527: l_sob_id number;

Line 524: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%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;
525: l_backlog Number;
526: l_rowid ROWID;
527: l_sob_id number;
528: l_coa_id number;