APPS.IGS_FI_VAL_CFT SQL Statements

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

Line: 27

  		SELECT	s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	fee_type= cp_fee_type;

Line: 81

  		SELECT	'x'
  		FROM	IGS_PS_FEE_TRG cft
  		WHERE	cft.fee_cat			= p_fee_cat AND
  			cft.fee_cal_type 		= p_fee_cal_type AND
  			cft.fee_ci_sequence_number 	= p_fee_ci_sequence_number AND
  			cft.fee_type				= p_fee_type AND
  			cft.course_cd			= p_course_cd AND
  			cft.sequence_number		<> NVL(p_sequence_number,0) AND
  			NVL(cft.version_number,0)	= NVL(p_version_number,0) AND
  			NVL(cft.cal_type,'NULL')	= NVL(p_cal_type,'NULL') AND
  			NVL(cft.location_cd,'NULL')	= NVL(p_location_cd,'NULL') AND
  			NVL(cft.attendance_mode,'NULL') = NVL(p_attendance_mode,'NULL') AND
  			NVL(cft.attendance_type,'NULL') = NVL(p_attendance_type,'NULL') AND
  			cft.create_dt			<> p_create_dt AND
  			NVL(cft.fee_trigger_group_number,0) = NVL(p_fee_trigger_group_number,0) AND
  			cft.logical_delete_dt IS NULL;

Line: 137

  		SELECT	'x'
  		FROM	IGS_PS_VER crv,
  			IGS_PS_STAT cs
  		WHERE	crv.course_cd = cp_course_cd AND
  			crv.course_status = cs.course_status AND
  			cs.s_course_status IN (cst_active, cst_planned);

Line: 175

  		SELECT	'x'
  		FROM	IGS_CA_TYPE cat
  		WHERE	cat.cal_type	= cp_cal_type AND
  			cat.s_cal_cat	= cst_academic;

Line: 207

  		SELECT	closed_ind
  		FROM	IGS_CA_TYPE
  		WHERE  cal_type  = p_cal_type;

Line: 253

            SELECT	s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE
  		WHERE  fee_type= cp_fee_type;

Line: 265

  		SELECT	'x'
  		FROM	IGS_PS_FEE_TRG cft
  		WHERE	cft.fee_cat= cp_fee_cat AND
  			cft.fee_cal_type = cp_fee_cal_type AND
  			cft.fee_ci_sequence_number = cp_fee_ci_sequence_num AND
  			cft.fee_type = cp_fee_type AND
  			cft.course_cd <> cp_course_cd AND
  			cft.fee_trigger_group_number = cp_fee_trigger_group_num AND
  			cft.logical_delete_dt IS NULL;