APPS.IGS_AS_VAL_GSGT SQL Statements

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

Line: 59

  		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 AND
  			gsgt.to_grading_schema_cd	= p_to_grading_schema_cd AND
  			gsgt.to_version_number 		= p_to_version_number AND
  			gsgt.to_grade 			<> p_to_grade;

Line: 154

  		SELECT	'x'
  		FROM	IGS_AS_SU_STMPTOUT	suao
  		WHERE	suao.grading_schema_cd			= p_grading_schema_cd		AND
  			suao.version_number			= p_version_number		AND
  			suao.grade				= p_grade			AND
  			suao.translated_grading_schema_cd	= p_to_grading_schema_cd	AND
  			suao.translated_version_number		= p_to_version_number		AND
  			suao.translated_grade			= p_to_grade			AND
  			suao.finalised_outcome_ind		= 'Y';