APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_EXCEPTIONS

Line 139: INSERT INTO igi_iac_exceptions (revaluation_id,

135: l_str:=fnd_message.get;
136: fnd_file.put_line(FND_FILE.LOG,l_str);
137: END IF;
138:
139: INSERT INTO igi_iac_exceptions (revaluation_id,
140: asset_id,
141: category_id,
142: book_type_code,
143: exception_message,

Line 159: FROM igi_iac_exceptions

155: sysdate,
156: l_user_id
157: FROM sys.dual
158: WHERE NOT EXISTS(SELECT 'X'
159: FROM igi_iac_exceptions
160: WHERE revaluation_id = p_revaluation_id
161: AND book_type_code = p_book_type_code
162: AND category_id = p_category_id
163: AND asset_id = p_asset_id);