APPS.IGS_FI_VAL_CGFT SQL Statements

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

Line: 21

  		SELECT	s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	fee_type = cp_fee_type;

Line: 66

  		SELECT	cgft.course_group_cd
  		FROM	IGS_PS_GRP_FEE_TRG cgft
  		WHERE	cgft.fee_cat		= p_fee_cat AND
  			cgft.fee_cal_type 	= p_fee_cal_type AND
  			cgft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			cgft.fee_type 		= p_fee_type AND
  			cgft.course_group_cd	= p_course_group_cd AND
  			cgft.create_dt		<> p_create_dt AND
  			cgft.logical_delete_dt IS NULL;