APPS.IGS_EN_GEN_004 dependencies on IGS_CA_STAT

Line 799: IGS_CA_STAT cs

795: FROM IGS_EN_SU_ATTEMPT sua,
796: IGS_CA_INST_REL cir,
797: IGS_CA_INST ci,
798: IGS_CA_TYPE cat,
799: IGS_CA_STAT cs
800: WHERE sua.person_id = p_person_id AND
801: sua.course_cd = p_course_cd AND
802: sua.unit_attempt_status <> cst_unconfirm AND
803: cir.sub_cal_type = sua.cal_type AND