192: igs_ca_type b ,
193: igs_ca_type c ,
194: igs_ca_inst d ,
195: igs_ca_inst e ,
196: igs_ca_stat f,
197: igs_ca_stat g
198: WHERE a.rowid = p_rowid
199: AND a.sub_cal_type = b.cal_type
200: AND b.s_cal_cat = 'ADMISSION'
193: igs_ca_type c ,
194: igs_ca_inst d ,
195: igs_ca_inst e ,
196: igs_ca_stat f,
197: igs_ca_stat g
198: WHERE a.rowid = p_rowid
199: AND a.sub_cal_type = b.cal_type
200: AND b.s_cal_cat = 'ADMISSION'
201: AND a.sup_cal_type = c.cal_type