APPS.IGS_AV_VAL_AS SQL Statements

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

Line: 18

  		SELECT	spa.course_cd
  		FROM	IGS_EN_STDNT_PS_ATT spa
  		WHERE	spa.person_id = cp_person_id AND
  			spa.course_cd = cp_course_cd AND
  			spa.version_number = cp_version_number AND
			spa.course_attempt_status IN
                   ('ENROLLED', 'INACTIVE', 'INTERMIT', 'UNCONFIRM', 'DISCONTIN','COMPLETED');

Line: 65

		SELECT ihp.oss_org_unit_cd exemption_institution_cd
		FROM igs_pe_hz_parties ihp
		 where ihp.inst_org_ind = 'I'
		 AND ihp.oi_govt_institution_cd IS NOT NULL
		 AND ihp.oss_org_unit_cd = cp_exempt_inst
		UNION ALL
		SELECT lk.lookup_code exemption_institution_cd
		FROM igs_lookup_values lk
		WHERE lk.lookup_type = 'OR_INST_EXEMPTIONS'
		 AND lk.enabled_flag = 'Y'
		 AND lk.lookup_code = cp_exempt_inst;

Line: 78

  	-- The status is not considered, as it is allowable to select an inactive
  	-- IGS_OR_INSTITUTION for advanced standing basis details.
  	 p_message_name := null;