APPS.IGS_AS_VAL_NESO SQL Statements

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

Line: 29

  		SELECT	sgcmt.closed_ind
  		FROM	IGS_LOOKUPS_VIEW sgcmt
  		WHERE	sgcmt.LOOKUP_TYPE = p_s_grade_creation_method_type;

Line: 33

  		SELECT	us.s_unit_status
  		FROM	IGS_PS_UNIT_VER uv,
  			IGS_PS_UNIT_STAT us
  		WHERE	uv.unit_cd = p_unit_cd AND
  			uv.version_number = p_version_number AND
  			us.UNIT_STATUS = uv.UNIT_STATUS;

Line: 40

  		SELECT	sca.person_id
  		FROM 	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.person_id = p_person_id;

Line: 44

  		SELECT	sca.person_id
  		FROM 	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.person_id = p_person_id AND
  			sca.course_cd = p_course_cd;

Line: 49

  	-- Validate the insert of a IGS_AS_NON_ENR_STDOT record.
  	-- Checks for:
  	-- cannot be added against a closed s_grade_creation_method_type
  	-- one of mark or grade must be set
  	-- cannot be added against IGS_PS_UNIT_VER with a system status of
  	-- other than 'ACTIVE'.
  	-- Person id must have at least one student course attempt of any status.
  	--- Set the default message number
  	p_message_name := null;