APPS.IGS_AS_VAL_ELS SQL Statements

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

Line: 21

  	SELECT	'x'
  	FROM	IGS_AD_LOCATION_TYPE	lot,
  		IGS_AD_LOCATION	loc
  	WHERE	lot.location_type	= loc.location_type AND
  		loc.location_cd		= p_exam_location_cd AND
  		lot.s_location_type <> 'EXAM_CTR';

Line: 62

  		SELECT	closed_ind
  		FROM	IGS_AD_LOCATION
  		WHERE	location_cd = cp_location_cd;