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_REVAL_VALIDATION dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 123: from igi_iac_transaction_headers

119: -- Added the condition to check for status not OBSOLETE to the cursor below
120:
121: cursor c_not_valid is
122: select 'x'
123: from igi_iac_transaction_headers
124: where asset_id = fp_asset_id
125: and book_type_code = fp_book_type_code
126: and period_counter = fp_period_counter
127: and mass_Reference_id <> fp_revaluation_id

Line 257: FROM igi_iac_transaction_headers

253: )
254: RETURN BOOLEAN IS
255: CURSOR c_preview_in_curr_period IS
256: SELECT mass_reference_id revaluation_id
257: FROM igi_iac_transaction_headers
258: WHERE asset_id = fp_asset_id
259: AND book_type_code = fp_book_type_code
260: AND period_counter = fp_period_counter
261: AND transaction_type_code = 'REVALUATION'