APPS.IGS_PS_VAL_COW SQL Statements

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

Line: 15

  		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: 22

  		SELECT	'x'
  		FROM	IGS_PS_OWN
  		WHERE	course_cd = p_course_cd AND
  			version_number = p_version_number;

Line: 29

     	   SELECT	SUM(percentage)
     	    	   FROM	IGS_PS_OWN
  	   WHERE	course_cd = p_course_cd AND
  		version_number = p_version_number;