APPS.IGS_AS_VAL_GSG SQL Statements

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

Line: 15

  		SELECT 	start_dt,
  			end_dt
  		FROM	IGS_AS_GRD_SCHEMA
  		WHERE	grading_schema_cd = p_grading_schema_cd AND
  			version_number = p_version_number;

Line: 168

  		SELECT	lower_mark_range,
  			upper_mark_range
  		FROM	IGS_AS_GRD_SCH_GRADE
  		WHERE	grading_schema_cd = p_grading_schema_cd AND
  			version_number = p_version_number AND
  			grade <> p_grade AND
  			p_lower_mark_range IS NOT NULL AND
  			p_upper_mark_range IS NOT NULL;

Line: 225

  		SELECT	COUNT(*)
  		FROM	IGS_AS_GRD_SCH_GRADE
  		WHERE	grading_schema_cd = p_grading_schema_cd AND
  			version_number = p_version_number AND
  			grade <> p_grade AND
  			dflt_outstanding_ind = 'Y';

Line: 276

  		SELECT	'x'
  		FROM	IGS_AS_GRD_SCH_TRN	gsgt
  		WHERE	gsgt.grading_schema_cd	= p_grading_schema_cd	AND
  			gsgt.version_number	= p_version_number	AND
  			gsgt.grade		= p_grade;

Line: 282

  		SELECT	'x'
  		FROM	IGS_AS_GRD_SCH_TRN	gsgt
  		WHERE	gsgt.to_grading_schema_cd	= p_grading_schema_cd	AND
  			gsgt.to_version_number		= p_version_number	AND
  			gsgt.to_grade			= p_grade;