APPS.IGS_EN_GEN_004 dependencies on IGS_CA_TYPE

Line 798: IGS_CA_TYPE cat,

794: cir.sup_ci_sequence_number
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