APPS.IGS_PS_VAL_UD SQL Statements

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

Line: 12

   		SELECT 	closed_ind
  		FROM	IGS_PS_DSCP
  		WHERE	discipline_group_cd = p_discipline_group_cd;

Line: 63

  		SELECT	US.s_unit_status
  		FROM	IGS_PS_UNIT_VER UV,
  			IGS_PS_UNIT_STAT US
  		WHERE	UV.unit_cd = p_unit_cd AND
  			UV.version_number = p_version_number AND
  			UV.unit_status = US.unit_status;

Line: 70

  		SELECT	'x'
  		FROM	IGS_PS_UNIT_DSCP
  		WHERE	unit_cd = p_unit_cd AND
  			version_number = p_version_number;

Line: 76

		SELECT 	SUM(percentage)
	 	FROM 	IGS_PS_UNIT_DSCP
  		WHERE unit_cd = p_unit_cd AND
  		version_number= p_version_number;