APPS.IGS_PS_VAL_CFOS SQL Statements

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

Line: 12

  		SELECT closed_ind
  		FROM   IGS_PS_FLD_OF_STUDY
  		WHERE  field_of_study = p_field_of_study;

Line: 45

  		SELECT	CS.s_course_status
  		FROM	IGS_PS_VER CV,
  			IGS_PS_STAT CS
  		WHERE	CV.course_cd = p_course_cd AND
  			CV.version_number = p_version_number AND
  			CV.course_status = CS.course_status;

Line: 52

  		SELECT	'x'
  		FROM	IGS_PS_FIELD_STUDY
  		WHERE	course_cd = p_course_cd AND
  			version_number = p_version_number;

Line: 59

		  	SELECT	NVL(SUM(percentage),0) sum_per,fos_type_code
		  	FROM	IGS_PS_FIELD_STUDY_V
		  	WHERE  FOS_TYPE_CODE <> 'CIP'
			AND	course_cd = cp_course_cd
			AND version_number = cp_version_number
			GROUP BY  fos_type_code
			HAVING Sum(percentage) <>100;

Line: 126

  		SELECT	CS.s_course_status
  		FROM	IGS_PS_VER CV,
  			IGS_PS_STAT CS
  		WHERE	CV.course_cd = p_course_cd AND
  			CV.version_number = p_version_number AND
  			CV.course_status = CS.course_status;

Line: 135

  		SELECT fos_type_code
		FROM IGS_PS_FIELD_STUDY_V out_fos
		WHERE FOS_TYPE_Code <> 'CIP'
		AND course_cd = cp_course_cd
		AND version_number = cp_version_number
		AND NOT EXISTS( SELECT in_fos.FOS_TYPE_Code
				FROM IGS_PS_FIELD_STUDY_V in_fos
				WHERE in_fos.FOS_TYPE_Code = out_fos.FOS_TYPE_Code
				AND in_fos.course_cd = out_fos.course_cd
				AND in_fos.version_number = out_fos.version_number
				AND major_field_ind = 'Y'
				GROUP BY in_fos.FOS_TYPE_Code
				HAVING Count(major_field_ind) = 1);

Line: 151

	  	SELECT  count(*)
	  	FROM	IGS_PS_FIELD_STUDY
	  	WHERE	course_cd = p_course_cd AND
  		version_number = p_version_number;

Line: 167

  	-- selecting IGS_PS_FIELD_STUDY records based on course_cd,
  	-- version_number and major_field_ind
   	OPEN c_course_field_of_study(p_course_cd,p_version_number);

Line: 175

  	-- record is selected with a major_field_ind = 'Y'
          CLOSE c_course_status;

Line: 181

  		-- when no records are selected for the given IGS_PS_VER
  		-- and the IGS_PS_STAT.s_unit_status is PLANNED
  		IF (v_course_status = 'PLANNED' AND v_count_records = 0) THEN
  			CLOSE c_course_status;

Line: 190

  			-- record is selected for the given IGS_PS_VER with a
  			-- major_field_ind = 'Y' and the IGS_PS_STAT.s_unit_status
  			-- is not PLANNED
  			CLOSE c_course_status;

Line: 221

     smvk     03-Jun-2003   Bug # 2858436. Modified the cursor c_get_cnt_course_award_rec to select open program awards only.
   ***************************************************************/

  	v_cnt_field_of_study_rec	NUMBER(5);

Line: 227

  		SELECT	count(*)
  		FROM	IGS_PS_FIELD_STUDY
  		WHERE	course_cd	= p_course_cd		AND
  			version_number	= p_version_number;

Line: 232

  		SELECT	count(*)
  		FROM	IGS_PS_AWARD
  		WHERE	course_cd	= p_course_cd		AND
  			version_number	= p_version_number      AND
                        closed_ind = 'N' ;