APPS.IGS_AS_VAL_AI SQL Statements

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

Line: 26

  		SELECT	examinable_ind
  		FROM	IGS_AS_ASSESSMNT_TYP
  		WHERE	assessment_type = cp_assessment_type;

Line: 91

  		SELECT	examinable_ind
  		FROM	IGS_AS_ASSESSMNT_TYP
  		WHERE	assessment_type = cp_assessment_type;

Line: 146

  		SELECT	closed_ind
  		FROM	IGS_AS_ASSESSMNT_TYP
  		WHERE	assessment_type = cp_assessment_type;

Line: 196

  		SELECT	'x'
  		FROM	IGS_AS_UNITASS_ITEM uai
  		WHERE 	ass_id	= p_ass_id AND
  			EXISTS (
  				SELECT	'x'
  				FROM	IGS_AS_UNITASS_ITEM uai2
  				WHERE	uai2.unit_cd 		= uai.unit_cd AND
  					uai2.version_number 	= uai.version_number AND
  					uai2.cal_type 		= uai.cal_type AND
  					uai2.ci_sequence_number = uai.ci_sequence_number AND
  					uai2.sequence_number 	<> uai.sequence_number AND
  					uai2.reference 		= uai.reference AND
  					uai2.logical_delete_dt 	IS NULL AND
  					EXISTS (
  						SELECT	'x'
  						FROM	IGS_AS_ASSESSMNT_ITM ai
  						WHERE	ai.ass_id 		= uai2.ass_id AND
  							ai.assessment_type 	= p_assessment_type)) AND
  		uai.logical_delete_dt IS NULL;

Line: 216

  		SELECT	atyp.s_assessment_type,
  			atyp.examinable_ind
  		FROM	IGS_AS_ASSESSMNT_TYP atyp
  		WHERE	atyp.assessment_type = cp_assessment_type;

Line: 221

  		SELECT	'x'
  		FROM	IGS_AS_SU_ATMPT_ITM suaai
  		WHERE	ass_id			= p_ass_id AND
  			suaai.logical_delete_dt IS NULL AND
  			suaai.tracking_id 	IS NOT NULL;

Line: 229

  		SELECT	'x'
  		FROM	IGS_AS_UNITASS_ITEM uai
  		WHERE 	ass_id	= p_ass_id AND
  			EXISTS (
  				SELECT	'x'
  				FROM	IGS_AS_UNITASS_ITEM uai2,
  					IGS_AS_ASSESSMNT_ITM ai,
  					IGS_AS_ASSESSMNT_TYP atyp
  				WHERE	uai2.unit_cd = uai.unit_cd AND
  					uai2.version_number = uai.version_number AND
  					uai2.cal_type = uai.cal_type AND
  					uai2.ci_sequence_number = uai.ci_sequence_number AND
  					uai2.sequence_number <> uai.sequence_number AND
  					uai2.reference = uai.reference AND
  					uai2.logical_delete_dt IS NULL AND
  					uai2.ass_id = ai.ass_id AND
  					ai.assessment_type = atyp.assessment_type AND
  					atyp.examinable_ind = 'Y');