APPS.IGS_EN_GEN_009 dependencies on IGS_CA_TYPE

Line 784: IGS_CA_TYPE cat,

780: SELECT tci.cal_type,
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