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_GEN_009 dependencies on IGS_CA_STAT

Line 761: IGS_CA_STAT cs

757: aci.sequence_number,
758: aci.start_dt,
759: aci.end_dt
760: FROM IGS_CA_INST aci,
761: IGS_CA_STAT cs
762: WHERE aci.cal_type = p_acad_cal_type AND
763: aci.start_dt > cp_start_dt AND
764: cs.cal_status = aci.cal_status AND
765: cs.s_cal_status = cst_active

Line 785: IGS_CA_STAT cs

781: tci.sequence_number
782: FROM IGS_CA_INST_REL cir,
783: IGS_CA_INST tci,
784: IGS_CA_TYPE cat,
785: IGS_CA_STAT cs
786: WHERE cir.sup_cal_type = cp_acad_cal_type AND
787: sup_ci_sequence_number = cp_acad_sequence_number AND
788: sub_cal_type = cp_teach_cal_type AND
789: tci.cal_type = cir.sub_cal_type AND