[Home] [Help]
870: IN
871: (
872: SELECT sup_cal_type,
873: sup_ci_sequence_number
874: FROM igs_ca_inst_rel
875: WHERE sub_cal_type = l_acad_cal_type
876: AND sub_ci_sequence_number = l_acad_seq_num
877: UNION
878: SELECT sub_cal_type,
876: AND sub_ci_sequence_number = l_acad_seq_num
877: UNION
878: SELECT sub_cal_type,
879: sub_ci_sequence_number
880: FROM igs_ca_inst_rel
881: WHERE sup_cal_type = l_acad_cal_type
882: AND sup_ci_sequence_number = l_acad_seq_num
883: )
884: AND