APPS.IGI_IAC_ADJ_EXPENSED_PKG dependencies on IGI_IAC_REVALUATION_RATES

Line 100: FROM igi_iac_revaluation_rates irr

96: WHERE book_type_code = p_asset_iac_adj_info.book_type_code;
97:
98: CURSOR C_get_curr_reval_rate IS
99: SELECT irr.*
100: FROM igi_iac_revaluation_rates irr
101: WHERE irr.asset_id = p_asset_iac_adj_info.asset_id
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)

Line 105: FROM igi_iac_revaluation_rates iar ,

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

Line 114: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;

110: AND ith.asset_id = p_asset_iac_adj_info.asset_id
111: AND iar.adjustment_id = ith.adjustment_id
112: AND ith.adjustment_status IN ('COMPLETE','RUN'));
113:
114: l_get_curr_reval_rate igi_iac_revaluation_rates%ROWTYPE;
115: l_cumulative_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
116: l_current_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
117: l_Reval_rsv_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;
118: l_operating_acct_backlog igi_iac_asset_balances.backlog_deprn_reserve%TYPE;