APPS.IGS_PR_GET_CLASS_STD dependencies on IGS_EN_SU_ATTEMPT

Line 127: FROM igs_en_su_attempt sua3,

123: AND cir2.sup_ci_sequence_number = ci1.sequence_number
124: AND ci2b.cal_type = ct2.cal_type
125: AND ct2.s_cal_cat = 'LOAD')
126: AND 0 < (SELECT COUNT(*)
127: FROM igs_en_su_attempt sua3,
128: igs_ca_inst_rel cir3
129: WHERE sua3.person_id = p_person_id
130: AND sua3.course_cd = p_course_cd
131: AND sua3.unit_attempt_status NOT IN