779: FROM igs_ca_inst ci,
780: igs_ca_inst endterm,
781: igs_ca_inst beginterm,
782: igs_ca_type ct,
783: igs_ca_stat cs,
784: igs_ca_inst_rel cr,
785: igs_ca_inst_rel cr2,
786: igs_ca_type ct2
787: WHERE ci.cal_type = cr.sub_cal_type
1005: FROM IGS_CA_INST ci,
1006: IGS_CA_INST ci2,
1007: IGS_CA_INST ci3,
1008: IGS_CA_TYPE ct,
1009: IGS_CA_STAT cs,
1010: IGS_CA_INST_REL cr,
1011: IGS_CA_INST_REL cr2,
1012: IGS_CA_TYPE ct2
1013: WHERE ci.cal_type = cr.sub_cal_type
2517: FROM igs_ca_inst ci2,
2518: igs_ca_inst_rel cir,
2519: igs_ca_type ct,
2520: igs_ca_inst ci1,
2521: igs_ca_stat cs
2522: WHERE
2523: ci2.cal_type = cir.sub_cal_type AND
2524: ci2.sequence_number = cir.sub_ci_sequence_number AND
2525: cir.sup_cal_type = p_cal_type AND
2587: FROM igs_ca_inst ci2,
2588: igs_ca_inst_rel cir,
2589: igs_ca_type ct,
2590: igs_ca_inst ci1,
2591: igs_ca_stat cs
2592: WHERE
2593: ci2.cal_type = cir.sub_cal_type AND
2594: ci2.sequence_number = cir.sub_ci_sequence_number AND
2595: cir.sup_cal_type = p_cal_type AND