APPS.IGS_OR_VAL_LR SQL Statements

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

Line: 22

  		SELECT	location_cd
  		FROM	IGS_AD_LOCATION_REL
  		WHERE	sub_location_cd = p_location_cd;

Line: 75

  	SELECT	closed_ind
  	FROM	IGS_AD_LOCATION
  	WHERE	location_cd = p_location_cd
  	AND	closed_ind = 'Y';

Line: 162

  	SELECT	'x'
  	FROM	IGS_AD_LOCATION_REL	lr,
  		IGS_AD_LOCATION			loc,
  		IGS_AD_LOCATION_TYPE		lot
  	WHERE	lr.location_cd	= p_location_cd	AND
  		lr.sub_location_cd	<> p_sub_location_cd AND
  		lr.dflt_ind	= 'Y' AND
  		lr.sub_location_cd = loc.location_cd AND
  		loc.location_type = lot.location_type AND
  		lot.s_location_type = p_sub_s_location_type;