APPS.IGS_PS_VAL_CAO SQL Statements

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

Line: 14

  		SELECT 'x'
  		FROM 	IGS_PS_AWD_OWN
  		WHERE	course_cd	= p_course_cd		AND
  			version_number	= p_version_number	AND
  			award_cd	= p_award_cd;

Line: 49

  		SELECT	CS.s_course_status
  		FROM	IGS_PS_VER CV,
  			IGS_PS_STAT CS
  		WHERE	CV.course_cd = p_course_cd AND
  			CV.version_number = p_version_number AND
  			CV.course_status = CS.course_status;

Line: 56

  		SELECT	'x'
  		FROM	IGS_PS_AWD_OWN
  		WHERE	course_cd = p_course_cd AND
  			version_number = p_version_number AND
  			award_cd = p_award_cd;

Line: 63

			  	SELECT	SUM(percentage)
  				FROM	IGS_PS_AWD_OWN
			  	WHERE	course_cd = p_course_cd AND
				  	version_number = p_version_number AND
					award_cd = p_award_cd;