APPS.IGS_PS_VAL_CRV SQL Statements

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

Line: 18

  		SELECT closed_ind
  		FROM   IGS_PS_GOVT_SPL_TYPE
  		WHERE  govt_special_course_type = p_govt_special_course_type;

Line: 59

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

  	v_closed_ind		IGS_PS_TYPE.closed_ind%TYPE;

Line: 66

  		SELECT	closed_ind,
  			award_course_ind
  		FROM   	IGS_PS_TYPE
  		WHERE  	course_type = p_course_type;

Line: 71

  		SELECT 	*
  		FROM	IGS_PS_AWARD
  		WHERE	course_cd = p_course_cd AND
  			version_number = p_version_number AND
                        CLOSED_IND = 'N';

Line: 127

  		SELECT s_org_status
  		FROM	igs_or_inst_org_base_v,
  			IGS_OR_STATUS
  		WHERE	party_number		= p_org_unit_cd		AND
  			start_dt			= p_start_dt		AND
  			igs_or_inst_org_base_v.org_status	= IGS_OR_STATUS.org_status;

Line: 165

  		SELECT s_course_status
  		FROM	IGS_PS_STAT
  		WHERE course_status = p_course_status;

Line: 212

  		SELECT s_course_status
  		FROM	IGS_PS_STAT
  		WHERE course_status = p_course_status;

Line: 216

  		SELECT 'x'
  		FROM	IGS_PS_VER	cv,
  			IGS_PS_STAT	cs
  		WHERE
  			course_cd 		 = p_course_cd 		AND
  			version_number		<> p_version_number	AND
  			expiry_dt		IS NULL			AND
  			cv.course_status	 = cs.course_status	AND
  			cs.s_course_status	 = 'ACTIVE';

Line: 265

  		SELECT 	closed_ind,
  			s_course_status
  		FROM   	IGS_PS_STAT
  		WHERE  	course_status = cp_course_status;

Line: 282

  	-- is being updated.
  	IF (p_old_course_status IS NOT NULL) AND
  	    (p_new_course_status <> p_old_course_status) THEN
  		OPEN c_course_status(p_old_course_status);

Line: 327

     smvk     03-Jun-2003   Bug # 2858436. Modified the cursor c_get_award_cd to select open program awards only.
     skpandey 10-Jul-2006   Bug#5343912,removed the validation of 100% Field of study as this was used as check for updating status to active.
   ***************************************************************/

	v_cv_rec		IGS_PS_VER%ROWTYPE;

Line: 341

  		SELECT *
  		FROM	IGS_PS_VER
  		WHERE	course_cd 	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 347

  		SELECT 	award_course_ind
  		FROM	IGS_PS_TYPE
  		WHERE course_type = cp_course_type;

Line: 351

  		SELECT 	award_cd
  		FROM	IGS_PS_AWARD
  		WHERE	course_cd 	= p_course_cd	AND
  			version_number	= p_version_number AND
                        CLOSED_IND = 'N';

Line: 357

  		SELECT	funding_source
  		FROM	IGS_FI_FND_SRC_RSTN
  		WHERE	course_cd	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 362

  		SELECT field_of_study
  		FROM	IGS_PS_FIELD_STUDY
  		WHERE	course_cd 	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 367

  		SELECT	course_cat
  		FROM	IGS_PS_CATEGORISE
  		WHERE	course_cd 	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 372

  		SELECT reference_cd_type
  		FROM	IGS_PS_REF_CD
  		WHERE	course_cd	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 377

  		SELECT	course_group_cd
  		FROM	IGS_PS_GRP_MBR
  		WHERE	course_cd	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 382

  		SELECT 	unit_cd,
  			uv_version_number
  		FROM	IGS_PS_ANL_LOAD_U_LN
  		WHERE	course_cd		= p_course_cd	AND
  			crv_version_number	=p_version_number;

Line: 388

  		SELECT cal_type
  		FROM	IGS_PS_OFR
  		WHERE	course_cd	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 393

  		SELECT	location_cd,
  			attendance_type,
  			attendance_mode
  		FROM	IGS_PS_OFR_OPT
  		WHERE	course_cd	= p_course_cd	AND
  			version_number	= p_version_number AND
                        delete_flag = 'N';

Line: 401

  		SELECT DISTINCT reference_cd_type
  		FROM	IGS_PS_ENT_PT_REF_CD
  		WHERE	course_cd	= p_course_cd	AND
  			version_number	= p_version_number;

Line: 406

  		SELECT	s_course_status
  		FROM	IGS_PS_STAT
  		WHERE	course_status 	= p_old_course_status;

Line: 410

  		SELECT cal_type, ci_sequence_number
  		FROM	IGS_PS_OFR_INST
  		WHERE	course_cd	= p_course_cd		AND
  			version_number	= p_version_number;

Line: 707

  		SELECT	'X'
  		FROM	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.course_cd = p_course_cd AND
  			sca.version_number = p_version_number AND
  			sca.course_attempt_status IN (
  						cst_enrolled,
  						cst_inactive,
  						cst_intermit);

Line: 716

  		SELECT	'X'
  		FROM	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.course_cd = p_course_cd AND
  			sca.version_number = p_version_number AND
  			sca.course_attempt_status IN (
  						cst_lapsed,
  						cst_unconfirm);