DBA Data[Home] [Help]

APPS.IGI_IMP_IAC_EXCEP_INER_PKG dependencies on IGI_MHC_REVAL_SUMMARY_PL_V

Line 233: From igi_mhc_reval_summary_pl_v

229: nvl(old_reval_reserve,0) old_reval_reserve,
230: nvl(new_reval_reserve,0) new_reval_reserve,
231: nvl(new_curr_yr_expense,0) new_curr_yr_expense,
232: nvl(new_backlog_deprn,0) new_backlog_deprn
233: From igi_mhc_reval_summary_pl_v
234: Where book_type_code = cp_tax_book
235: and asset_id = p_asset_id
236: and period_counter = (select Max(period_counter) from igi_mhc_reval_summary_pl_v
237: Where book_type_code = cp_tax_book

Line 236: and period_counter = (select Max(period_counter) from igi_mhc_reval_summary_pl_v

232: nvl(new_backlog_deprn,0) new_backlog_deprn
233: From igi_mhc_reval_summary_pl_v
234: Where book_type_code = cp_tax_book
235: and asset_id = p_asset_id
236: and period_counter = (select Max(period_counter) from igi_mhc_reval_summary_pl_v
237: Where book_type_code = cp_tax_book
238: and asset_id = p_asset_id)
239: and reval_mode = 'INDEXED'
240: and active_flag= 'Y'