[Home] [Help]
301: ci.sequence_number sequence_number,
302: ci.alternate_code alternate_code
303: FROM igs_ca_inst ci,
304: igs_ca_type ct,
305: igs_ca_stat st
306: WHERE ct.s_cal_cat = 'AWARD'
307: AND ct.cal_type = ci.cal_type
308: AND ci.cal_status = st.cal_status
309: AND st.s_cal_status = 'ACTIVE'