APPS.IGS_AD_VAL_AALP SQL Statements

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

Line: 15

  		SELECT	closed_ind
  		FROM	IGS_CO_LTR_PARM_TYPE
  		WHERE	letter_parameter_type = p_letter_parameter_type;

Line: 47

  		SELECT	'x'
  		FROM	IGS_CO_LTR_PARM_TYPE
  		WHERE	letter_parameter_type 	= p_letter_parameter_type AND
  			s_letter_parameter_type = 'PHRASE' AND
  			closed_ind 		= 'N';

Line: 82

  		SELECT	closed_ind
  		FROM	IGS_CO_LTR_PHR
  		WHERE	phrase_cd = p_phrase_cd;