APPS.IGS_AS_VAL_EVSA SQL Statements

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

Line: 24

  		SELECT	'x'
  		From	IGS_AS_EXAM_INSTANCE
  		WHERE	ese_id 	 = p_ese_id AND
  			venue_cd = p_venue_cd;

Line: 64

  		SELECT	s_cal_status
  		FROM	IGS_CA_STAT	cs,
  			IGS_CA_INST	ci
  		WHERE	cs.cal_status		= ci.cal_status AND
  			ci.sequence_number	= cp_sequence_number AND
  			ci.cal_type		= cp_cal_type;