APPS.IGS_RE_VAL_DMS SQL Statements

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

Line: 20

  		SELECT	dms.course_cd,
  			dms.version_number,
  			dms.attendance_type,
  			dms.milestone_type,
  			dms.offset_days,
  			count('x')		duplicate_count
  		FROM	IGS_RE_DFLT_MS_SET	dms
  		WHERE	course_cd		= p_course_cd AND
  			dms.version_number	= p_version_number AND
  			dms.attendance_type	= p_attendance_type
  		GROUP BY
  			dms.course_cd,
  			dms.version_number,
  			dms.attendance_type,
  			dms.milestone_type,
  			dms.offset_days;