APPS.IGS_AD_VAL_ITT SQL Statements

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

Line: 15

  		SELECT	closed_ind
  		FROM	IGS_LOOKUP_VALUES
  		WHERE	lookup_type = 'INTAKE_TARGET_TYPE'
                AND     lookup_code = p_s_intake_target_type;

Line: 62

  		SELECT	'x'
  		FROM	IGS_AD_INTAK_TRG_TYP itt
  		WHERE	itt.intake_target_type 	<> p_intake_target_type 	AND
  			itt.s_intake_target_type 	= p_s_intake_target_type 	AND
  			itt.s_amount_type 		= p_s_amount_type	AND
  			itt.closed_ind		= 'N';