APPS.IGS_RU_VAL_RUD SQL Statements

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

Line: 66

  			SELECT	s_return_type
  			FROM	IGS_RU_RET_TYPE
  			WHERE	s_return_type LIKE SUBSTR(p_description,v_hash + 1,1)||'%'
  			ORDER BY s_return_type DESC )
  		LOOP
  			IF SUBSTR(p_description,v_hash + 1,LENGTH(return_types.s_return_type))
  				= return_types.s_return_type
  			THEN
  				p_action := return_types.s_return_type;

Line: 202

  			SELECT	COUNT(*)
  			INTO	v_turing_count
  			FROM	IGS_RU_ITEM
  			WHERE	turin_function = p_old_turing_function;

Line: 207

  			SELECT	COUNT(*)
  			INTO	v_nr_count
  			FROM	IGS_RU_NAMED_RULE	nr,
  				IGS_RU_ITEM	rui
  			WHERE	nr.rud_sequence_number = p_old_sequence_number
  			AND	rui.named_rule = nr.rul_sequence_number;