eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_GET_CLASS_STD dependencies on IGS_CA_INST_REL

Line 116: igs_ca_inst_rel cir2

112: AND 0 < (SELECT COUNT(*)
113: FROM igs_ca_inst ci2a,
114: igs_ca_inst ci2b,
115: igs_ca_type ct2,
116: igs_ca_inst_rel cir2
117: WHERE ci2a.cal_type = cp_load_cal_type
118: AND ci2a.sequence_number = cp_load_ci_sequence_number
119: AND TRUNC(ci2a.end_dt) >= TRUNC(ci2b.end_dt)
120: AND cir2.sub_cal_type = ci2b.cal_type

Line 128: igs_ca_inst_rel cir3

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
132: ('UNCONFIRM', 'DROPPED','DISCONTIN', 'WAITLISTED')

Line 176: igs_ca_inst_rel cir

172: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
173: SELECT sup_cal_type,
174: sup_ci_sequence_number
175: FROM igs_ca_type ct,
176: igs_ca_inst_rel cir
177: WHERE cir.sub_cal_type = cp_load_cal_type
178: AND cir.sub_ci_sequence_number = cp_load_ci_sequence_number
179: AND cir.sup_cal_type = ct.cal_type
180: AND ct.s_cal_cat = 'ACADEMIC';