APPS.IGS_OR_VAL_INS SQL Statements

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

Line: 45

  		SELECT	ps.person_id

  		FROM	IGS_PE_STATISTICS ps

  		WHERE	ps.prior_ug_inst = cp_institution_cd;

Line: 55

  		SELECT	advs.course_cd

  		FROM	IGS_AV_ADV_STANDING advs

  		WHERE	advs.exemption_institution_cd = cp_institution_cd;

Line: 91

  	-- institution record trying to be deleted was

  	-- being used by the prior_ug_inst column on the

  	-- IGS_PE_STATISTICS table

  	IF (c_person_stats%FOUND) THEN

  		CLOSE c_person_stats;

Line: 123

  	-- institution record trying to be deleted was

  	-- being used by the exemption_institution_cd

  	-- column on the IGS_AV_ADV_STANDING table

  	IF (c_advanced_stand%FOUND) THEN

  		CLOSE c_advanced_stand;

Line: 171

  	SELECT	enabled_flag

  	FROM	igs_lookup_values

  	WHERE	lookup_type = 'OR_INST_GOV_CD'

  	AND	enabled_flag = 'N'

	AND     lookup_code  = p_govt_institution_cd;

Line: 231

  	SELECT	closed_ind,

  		s_institution_status

  	INTO	v_closed_ind,

  		v_s_institution_status

  	FROM	IGS_OR_INST_STAT

  	WHERE	institution_status = p_institution_status;

Line: 297

  	SELECT	org_unit_cd

  	FROM	IGS_OR_UNIT,

  		IGS_OR_STATUS

  	WHERE	institution_cd = p_institution_cd

  	AND	IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status

  	AND	IGS_OR_STATUS.s_org_status = 'ACTIVE';