APPS.IGS_OR_VAL_LOC SQL Statements

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

Line: 10

  	SELECT	closed_ind
  	FROM	IGS_AD_LOCATION_TYPE
  	WHERE	location_type = p_location_type
  	AND	closed_ind = 'Y';

Line: 78

  	SELECT	'x'
  	FROM	IGS_GR_VENUE
  	WHERE	exam_location_cd	= p_location_cd AND
  		closed_ind		= 'N';

Line: 127

  	SELECT	'x'
  	FROM	IGS_GR_VENUE
  	WHERE	exam_location_cd	= p_location_cd;