APPS.IGS_PS_VAL_CRS SQL Statements

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

Line: 13

  		SELECT	s_course_status
  		FROM	IGS_PS_VER,
  			IGS_PS_STAT
  		WHERE	course_cd			= p_course_cd		AND
  			version_number			= p_version_number	AND
  			IGS_PS_VER.course_status	= IGS_PS_STAT.course_status;

Line: 21

  	-- updates or inserts can be made to IGS_PS_COURSE detail records.
  	p_message_name := NULL;