DBA Data[Home] [Help]

APPS.IGS_RE_VAL_SEOCC SQL Statements

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

Line: 15

  		SELECT	COUNT(govt_seo_class_cd)
  		FROM	IGS_RE_SEO_CLASS_CD
  		WHERE	govt_seo_class_cd	= p_govt_seo_class_cd AND
  			closed_ind		= 'N';
Line: 53

  		SELECT 	'X'
  		FROM	IGS_RE_GV_SEO_CLS_CD
  		WHERE 	govt_seo_class_cd = p_govt_seo_class_cd AND
  			closed_ind = 'Y';