APPS.IGS_PS_VAL_FSR SQL Statements

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

Line: 12

  		SELECT	COUNT(*)
  		FROM	IGS_FI_FND_SRC_RSTN
  		WHERE	course_cd = p_course_cd AND
  			version_number = p_version_number;

Line: 17

  		SELECT	COUNT(*)
  		FROM	IGS_FI_FND_SRC_RSTN
  		WHERE	course_cd = p_course_cd AND
  			version_number = p_version_number AND
  			restricted_ind = 'Y';

Line: 92

  		SELECT closed_ind
  		FROM   IGS_FI_FUND_SRC
  		WHERE  funding_source = p_funding_source;

Line: 127

  		SELECT	*
  		FROM	IGS_FI_FND_SRC_RSTN
  		WHERE	course_cd 	= p_course_cd 		AND
  			version_number 	= p_version_number 	AND
  			dflt_ind 		= 'Y';

Line: 139

  		-- none or one record is selected
  		CLOSE c_funding_source_rest;

Line: 144

  		-- more than one record is selected
  		CLOSE c_funding_source_rest;