[Home] [Help]
778: ci.alternate_code, ci.description
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
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
788: AND ci.sequence_number = cr.sub_ci_sequence_number
789: AND cr.sup_cal_type = ct2.cal_type
790: AND ct2.s_cal_cat = 'ACADEMIC'
1004: ci.start_dt, ci.alternate_code, ci.description
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
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
1014: AND ci.sequence_number = cr.sub_ci_sequence_number
1015: AND cr.sup_cal_type = ct2.cal_type
1016: AND ct2.s_cal_cat = 'ACADEMIC'
1180: p_program_changed IN BOOLEAN DEFAULT FALSE
1181: )
1182: AS
1183: cursor c_valid_term IS
1184: SELECT 'x' FROM IGS_CA_INST ca, IGS_CA_TYPE ct
1185: WHERE ca.cal_type = p_term_cal_type
1186: AND ca.sequence_number = p_term_sequence_number
1187: AND ca.cal_type = ct.cal_type
1188: and ct.s_cal_cat = 'LOAD';
2515: p_cur_term_seq_num IN NUMBER) IS
2516: SELECT RPAD(ci2.sequence_number,6,' ') || ci2.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
2585: p_cur_term_seq_num IN NUMBER) IS
2586: SELECT RPAD(ci2.sequence_number,6,' ') || ci2.cal_type
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