Line 94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir
90: --
91: CURSOR get_load_cal_inst (p_acad_cal_type IN VARCHAR2 , p_acad_ci_sequence_number IN NUMBER ,
92: p_start_dt IN DATE , p_end_dt IN DATE )IS
93: SELECT ci.cal_type , ci.start_dt , ci.end_dt , ci.sequence_number 94: FROM igs_ca_inst ci , igs_ca_type ct , igs_ca_stat cs , igs_ca_inst_rel cir 95: WHERE ct.cal_type = ci.cal_type
96: AND ct.s_cal_cat = 'LOAD'
97: AND cir.sup_cal_type = p_acad_cal_type
98: AND cir.sup_ci_sequence_number = p_acad_ci_sequence_number