APPS.IGS_RE_VAL_CAFOS SQL Statements

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

Line: 26

		SELECT NVL(Sum(cafos.percentage), 0) total, cafos.fos_type_code
		FROM     igs_re_cdt_fld_of_sy_v cafos
		WHERE    cafos.fos_type_code <> 'CIP'
		AND      cafos.person_id = p_person_id
		AND      cafos.ca_sequence_number = p_ca_sequence_number
		GROUP BY cafos.fos_type_code
		HAVING Sum(cafos.percentage)<>100;

Line: 75

  		SELECT	gfos.res_fcd_class_ind
  		FROM	IGS_PS_FLD_OF_STUDY		fos,
  			IGS_RE_GV_FLD_OF_SDY	gfos
  		WHERE	fos.field_of_study	= p_field_of_study	AND
  			Fos.govt_field_of_study = gfos.govt_field_of_study;

Line: 82

  		SELECT	'x'
  		FROM	IGS_RE_CDT_FLD_OF_SY	cafos,
  			IGS_PS_FLD_OF_STUDY		fos,
  			IGS_RE_GV_FLD_OF_SDY	gfos
  		WHERE	cafos.person_id			= p_person_id			AND
  			cafos.ca_sequence_number	= p_ca_sequence_number		AND
  			cafos.field_of_study		<> p_field_of_study		AND
  			cafos.field_of_study		= fos.field_of_study		AND
  			fos.govt_field_of_study		= gfos.govt_field_of_study	AND
  			gfos.res_fcd_class_ind		<> cp_res_fcd_class_ind;

Line: 150

  		SELECT 	'X'
  		FROM	IGS_PS_FLD_OF_STUDY fos
  		WHERE	fos.field_of_study	= p_field_of_study AND
  			fos.closed_ind = 'Y';