APPS.IGS_AS_VAL_AIEM SQL Statements

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

Line: 44

  	SELECT	'x'
  	FROM	IGS_AS_ASSESSMNT_TYP	atyp,
  		IGS_AS_ASSESSMNT_ITM	ai
  	WHERE	atyp.assessment_type	= ai.assessment_type	AND
  		ai.ass_id		= p_ass_id		AND
  		atyp.examinable_ind = 'N';

Line: 83

  	SELECT	'x'
  	FROM	IGS_AS_EXM_MTRL_TYPE
  	WHERE	exam_material_type	= p_exam_material_type	AND
  		closed_ind = 'Y';