APPS.IGS_PS_VAL_CST SQL Statements

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

Line: 23

  		SELECT	'x'
  		FROM	IGS_PS_STAGE
  		WHERE	course_cd		= p_course_cd AND
  			version_number		= p_version_number AND
  			sequence_number		<> NVL(p_sequence_number, -1) AND
  			course_stage_type	= p_course_stage_type;

Line: 75

  		SELECT	closed_ind
  		FROM	IGS_PS_STAGE_TYPE
  		WHERE	course_stage_type = p_course_stage_type;