APPS.IGS_EN_VAL_DR SQL Statements

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

Line: 47

  		SELECT 	closed_ind
  		FROM	IGS_LOOKUPS_VIEW sdrt
  		WHERE	lookup_type = 'DISCONTINUATION_REASON_TYPE' and
			lookup_code = p_s_discontin_reason_type;

Line: 94

  		SELECT	COUNT(*)
  		FROM	IGS_EN_DCNT_REASONCD		dr
  		WHERE	dr.s_discontinuation_reason_type	= p_s_discontin_reason_type AND
  			dr.closed_ind = 'N' AND
  			dr.sys_dflt_ind = 'Y';

Line: 141

  		SELECT 	COUNT(*)
  		FROM	IGS_EN_DCNT_REASONCD		dr
  		WHERE	dr.s_discontinuation_reason_type	= p_s_discontin_reason_type AND
  			dr.closed_ind				= 'N' AND
  			dr.sys_dflt_ind				= 'Y';

Line: 186

      SELECT count(*) cnt
      FROM igs_en_dcnt_reasoncd_v
      WHERE dcnt_unit_ind = 'Y'
      AND dflt_ind = 'Y'
      AND closed_ind = 'N';

Line: 193

      SELECT count(*) cnt
      FROM igs_en_dcnt_reasoncd
      WHERE  dcnt_program_ind = 'Y'
      AND dflt_ind = 'Y'
      AND closed_ind = 'N';