APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_REVALUATION_RATES

Line 270: FROM igi_iac_revaluation_rates rr,

266: AND a.asset_type <> 'CIP' -- bug 3416315
267: AND b.transaction_header_id_out IS NULL
268: AND b.date_placed_in_service <= p_revaluation_date
269: AND NOT EXISTS(SELECT 'X'
270: FROM igi_iac_revaluation_rates rr,
271: igi_iac_revaluations r
272: WHERE r.revaluation_id = rr.revaluation_id
273: AND rr.asset_id = a.asset_id
274: AND r.book_type_code = rr.book_type_code

Line 295: CURSOR c_get_last_reval_period_count(p_asset_id IN igi_iac_revaluation_rates.asset_id%TYPE) IS

291: AND r.transaction_header_id_out IS NULL
292: AND t.transaction_type_code = 'FULL RETIREMENT'
293: );
294:
295: CURSOR c_get_last_reval_period_count(p_asset_id IN igi_iac_revaluation_rates.asset_id%TYPE) IS
296: SELECT period_counter
297: FROM igi_iac_revaluation_rates
298: WHERE asset_id = p_asset_id
299: AND latest_record = 'Y'

Line 297: FROM igi_iac_revaluation_rates

293: );
294:
295: CURSOR c_get_last_reval_period_count(p_asset_id IN igi_iac_revaluation_rates.asset_id%TYPE) IS
296: SELECT period_counter
297: FROM igi_iac_revaluation_rates
298: WHERE asset_id = p_asset_id
299: AND latest_record = 'Y'
300: AND book_type_code = p_book_type_code;
301: