APPS.IGS_OR_VAL_INS dependencies on IGS_AV_ADV_STANDING

Line 39: v_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE;

35: DECLARE
36:
37: v_person_id IGS_PE_STATISTICS.person_id%TYPE;
38:
39: v_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE;
40:
41: CURSOR c_person_stats (
42:
43: cp_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS

Line 57: FROM IGS_AV_ADV_STANDING advs

53: cp_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS
54:
55: SELECT advs.course_cd
56:
57: FROM IGS_AV_ADV_STANDING advs
58:
59: WHERE advs.exemption_institution_cd = cp_institution_cd;
60:
61: BEGIN

Line 127: -- column on the IGS_AV_ADV_STANDING table

123: -- institution record trying to be deleted was
124:
125: -- being used by the exemption_institution_cd
126:
127: -- column on the IGS_AV_ADV_STANDING table
128:
129: IF (c_advanced_stand%FOUND) THEN
130:
131: CLOSE c_advanced_stand;