eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_REVALUATION_RATES

Line 123: FROM igi_iac_revaluation_rates irr

119: WHERE book_type_code = p_asset_iac_adj_info.book_type_code;
120:
121: CURSOR C_get_curr_reval_rate IS
122: SELECT irr.*
123: FROM igi_iac_revaluation_rates irr
124: WHERE irr.asset_id = p_asset_iac_adj_info.asset_id
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)

Line 128: FROM igi_iac_revaluation_rates iar ,

124: WHERE irr.asset_id = p_asset_iac_adj_info.asset_id
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

Line 137: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;

133: AND ith.asset_id = p_asset_iac_adj_info.asset_id
134: AND iar.adjustment_id = ith.adjustment_id
135: AND ith.adjustment_status IN ('COMPLETE','RUN'));
136:
137: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;
138: l_cumulative_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
139: l_current_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
140: l_Reval_rsv_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
141: l_operating_acct_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;