APPS.IGS_PS_VAL_UOO SQL Statements

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

Line: 22

  		SELECT 	IGS_AD_LOCATION.closed_ind,
  			location_type
  		FROM	IGS_AD_LOCATION
  		WHERE	location_cd = cp_location_cd;

Line: 28

  		SELECT 	s_location_type
  		FROM	IGS_AD_LOCATION_TYPE
  		WHERE	location_type = cp_location_type;

Line: 70

  	SELECT	closed_ind
  	FROM	IGS_AS_UNIT_CLASS
  	WHERE	unit_class = p_unit_class AND
  		closed_ind = 'Y';

Line: 106

  		SELECT  IGS_EN_GEN_003.Get_Staff_Ind(party_id) staff_member_ind
  		FROM    hz_parties
  		WHERE   party_id = p_person_id;