APPS.IGS_RE_VAL_CSC SQL Statements

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

Line: 25

  		SELECT 	NVL(sum(csc.percentage),0)
  		FROM	IGS_RE_CAND_SEO_CLS csc
  		WHERE 	csc.person_id		= p_person_id AND
  			csc.ca_sequence_number 	= p_ca_sequence_number;

Line: 71

  		SELECT	gscc.res_fcd_class_ind
  		FROM	IGS_RE_SEO_CLASS_CD		seocc,
  			IGS_RE_GV_SEO_CLS_CD	gscc
  		WHERE	seocc.seo_class_cd	= p_seo_class_cd AND
  			seocc.govt_seo_class_cd	= gscc.govt_seo_class_cd;

Line: 79

  		SELECT	'X'
  		FROM	IGS_RE_CAND_SEO_CLS 		csc,
   			IGS_RE_SEO_CLASS_CD 		seocc,
  			IGS_RE_GV_SEO_CLS_CD 	gscc
  		WHERE	csc.person_id 		= p_person_id AND
  			csc.ca_sequence_number	= p_ca_sequence_number AND
  			csc.seo_class_cd	<>p_seo_class_cd AND
  			csc.seo_class_cd	= seocc.seo_class_cd AND
  			seocc.govt_seo_class_cd	= gscc.govt_seo_class_cd AND
  			gscc.res_fcd_class_ind	<>cp_res_fcd_class_ind;

Line: 132

  		SELECT	'X'
  		FROM	IGS_RE_SEO_CLASS_CD		seocc
  		WHERE	seocc.seo_class_cd 	= p_seo_class_cd AND
  			seocc.closed_ind 	= 'Y';