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_EN_DASHBOARD dependencies on IGS_CA_INST_ALL

Line 74: igs_ca_inst_all ci,

70: ci.start_dt start_dt,
71: ci.planning_flag planning_flag,
72: ci.schedule_flag schedule_flag
73: FROM igs_en_stdnt_ps_att_all sca,
74: igs_ca_inst_all ci,
75: igs_ca_type ca,
76: igs_ca_stat cs,
77: igs_ca_inst_rel car,
78: igs_ps_ver_all pv

Line 108: IGS_CA_INST_ALL cai,

104: cai.planning_flag planning_flag,
105: cai.schedule_flag schedule_flag
106: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
107: IGS_CA_INST_REL car,
108: IGS_CA_INST_ALL cai,
109: IGS_CA_TYPE ca,
110: IGS_CA_STAT cs
111: WHERE sca.person_id = cp_n_person_id
112: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE', 'INTERMIT')

Line 127: FROM IGS_CA_INST_ALL ci,

123:
124: -- Cursor to determine whether finds unit section to be rendered or not.
125: CURSOR c_srch_allwd IS
126: SELECT 1
127: FROM IGS_CA_INST_ALL ci,
128: IGS_CA_TYPE ca,
129: IGS_CA_STAT cs
130: WHERE ci.ss_displayed = 'Y'
131: AND ci.cal_type = ca.cal_type