DBA Data[Home] [Help]

APPS.IGS_AV_VAL_ASAU SQL Statements

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

Line: 23

  		SELECT	'x'
  		FROM	IGS_AV_STND_UNIT
  		WHERE	person_id	 		= p_person_id		AND
  			as_course_cd		= p_course_cd		AND
  			as_version_number 	= p_course_version	AND
  			s_adv_stnd_type		= p_adv_stnd_type		AND
  			unit_cd			= p_unit_cd			AND
  			version_number		= p_unit_version		AND
  			s_adv_stnd_recognition_type	= 'PRECLUSION';