APPS.IGS_FI_VAL_CTFT SQL Statements

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

Line: 22

  		SELECT	s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	fee_type = cp_fee_type;

Line: 67

  		SELECT	ctft.course_type
  		FROM	IGS_PS_TYPE_FEE_TRG ctft
  		WHERE	ctft.fee_cat		= p_fee_cat AND
  			ctft.fee_cal_type 	= p_fee_cal_type AND
  			ctft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			ctft.fee_type		= p_fee_type AND
  			ctft.course_type	= p_course_type AND
  			ctft.create_dt		<> p_create_dt AND
  			ctft.logical_delete_dt IS NULL;