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_STAT

Line 76: igs_ca_stat cs,

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
79: WHERE sca.person_id = cp_n_person_id
80: AND sca.course_cd = pv.course_cd

Line 110: IGS_CA_STAT cs

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')
113: AND sca.cal_type =car.sup_cal_type
114: AND cai.cal_type = car.sub_cal_type

Line 129: IGS_CA_STAT cs

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
132: AND ca.s_cal_cat = 'LOAD'
133: AND ci.cal_status = cs.cal_status