APPS.IGS_EN_GEN_009 dependencies on IGS_CA_INST_REL

Line 782: FROM IGS_CA_INST_REL cir,

778: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
779: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE) IS
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