APPS.HRWSCAL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 55

  select EXCEPTION_ID,
	 PATTERN_ID,
	 EXCEPTION_CATEGORY,
	 EXCEPTION_START_TIME,
	 EXCEPTION_END_TIME,
	 PATTERN_NAME,
	 EXCEPTION_CATEGORY_MEANING
  from   hr_pattern_exceptions_v
  where  upper(exception_name) = upper(p_exception_name);