DBA Data[Home] [Help]

APPS.IGS_AS_VAL_VE SQL Statements

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

Line: 22

  	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' OR
  		lot.s_location_type = 'GRD_CTR';