APPS.IGS_PS_VAL_TR SQL Statements

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

Line: 27

  		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: 34

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

Line: 39

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