APPS.IGS_OR_VAL_INS dependencies on IGS_PE_STATISTICS

Line 37: v_person_id IGS_PE_STATISTICS.person_id%TYPE;

33: BEGIN
34:
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 (

Line 47: FROM IGS_PE_STATISTICS ps

43: cp_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS
44:
45: SELECT ps.person_id
46:
47: FROM IGS_PE_STATISTICS ps
48:
49: WHERE ps.prior_ug_inst = cp_institution_cd;
50:
51: CURSOR c_advanced_stand (

Line 77: -- VALIDATE THE IGS_PE_STATISTICS TABLE

73: -- Set the default message number
74:
75: p_message_name := NULL;
76:
77: -- VALIDATE THE IGS_PE_STATISTICS TABLE
78:
79: -- Get the person_id based on the institution
80:
81: -- code entered

Line 95: -- IGS_PE_STATISTICS table

91: -- institution record trying to be deleted was
92:
93: -- being used by the prior_ug_inst column on the
94:
95: -- IGS_PE_STATISTICS table
96:
97: IF (c_person_stats%FOUND) THEN
98:
99: CLOSE c_person_stats;