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_IMP_IAC_PREPARE_PKG dependencies on IGI_MHC_REVALUATION_SUMMARY

Line 516: From igi_mhc_revaluation_summary

512: Group by asset_id;
513:
514: Cursor C_Max_Period_Counter(p_asset_id in number) Is
515: Select max(period_counter) period_counter
516: From igi_mhc_revaluation_summary
517: Where book_type_code = p_book
518: and asset_id = p_asset_id
519: and reval_mode = 'INDEXED'
520: and active_flag= 'Y'

Line 536: From igi_mhc_revaluation_summary

532: nvl(old_reval_reserve,0) old_reval_reserve,
533: nvl(new_reval_reserve,0) new_reval_reserve,
534: nvl(new_curr_yr_expense,0) new_curr_yr_expense,
535: nvl(new_backlog_deprn,0) new_backlog_deprn
536: From igi_mhc_revaluation_summary
537: Where book_type_code = p_book
538: and period_counter = p_period_counter
539: and asset_id = p_asset_id
540: and reval_mode = 'INDEXED'