APPS.IGS_AS_GEN_008 dependencies on IGS_AS_GRD_SCH_GRADE

Line 137: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;

133: -- has any other records created by repeat process
134:
135: DECLARE
136:
137: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
138: v_repeat_grade_exists VARCHAR2(1) := 'N';
139:
140: CURSOR c_rg IS
141: SELECT suao.grade

Line 143: igs_as_grd_sch_grade gsg

139:
140: CURSOR c_rg IS
141: SELECT suao.grade
142: FROM igs_as_suaoa_v suao,
143: igs_as_grd_sch_grade gsg
144: WHERE suao.person_id = p_person_id
145: AND suao.unit_cd = p_unit_cd
146: AND (suao.course_cd <> p_course_cd
147: -- anilk, 22-Apr-2003, Bug# 2829262