[Home] [Help]
594: SELECT ci.cal_type,
595: ci.sequence_number
596: FROM igs_ca_inst_all ci,
597: igs_ca_type cat,
598: igs_ca_stat cs
599: WHERE (ci.alternate_code = p_alternate_code
600: OR p_alternate_code IS NULL
601: )
602: AND ((ci.cal_type = p_cal_type