APPS.IGS_AD_VAL_APCL SQL Statements

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

Line: 23

  		SELECT	closed_ind
  		FROM	IGS_CO_S_LTR
  		WHERE	correspondence_type	= p_correspondence_type AND
  			letter_reference_number	= p_letter_reference_number;

Line: 58

  		SELECT	'x'
  		FROM	IGS_CO_S_LTR	sl
  		WHERE	sl.correspondence_type		= p_correspondence_type		AND
  			sl.letter_reference_number 	= p_letter_reference_number	AND
  			sl.s_letter_reference_type	= p_s_letter_reference_type;