557: ORDER BY discontinued_dt DESC;
558:
559: CURSOR cur_term_cal(p_cal_type VARCHAR2,p_ci_sequence_number NUMBER, p_discontinued_dt DATE) IS
560: SELECT *
561: FROM IGS_CA_TEACH_TO_LOAD_V
562: WHERE teach_cal_type = p_cal_type
563: AND teach_ci_sequence_number = p_ci_sequence_number
564: AND load_start_dt <= TRUNC(p_discontinued_dt)
565: ORDER BY load_start_dt DESC;
573:
574:
575: CURSOR cur_term_cal_grd(p_cal_type VARCHAR2,p_ci_sequence_number NUMBER) IS
576: SELECT *
577: FROM IGS_CA_TEACH_TO_LOAD_V
578: WHERE teach_cal_type = p_cal_type
579: AND teach_ci_sequence_number = p_ci_sequence_number
580: ORDER BY load_end_dt DESC;
581:
578: WHERE teach_cal_type = p_cal_type
579: AND teach_ci_sequence_number = p_ci_sequence_number
580: ORDER BY load_end_dt DESC;
581:
582: lv_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE;
583: lv_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE;
584: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
585:
586: cur_unit_atmpt_dis_rec cur_unit_atmpt_dis%ROWTYPE;
579: AND teach_ci_sequence_number = p_ci_sequence_number
580: ORDER BY load_end_dt DESC;
581:
582: lv_cal_type IGS_CA_TEACH_TO_LOAD_V.teach_cal_type%TYPE;
583: lv_ci_sequence_number IGS_CA_TEACH_TO_LOAD_V.teach_ci_sequence_number%TYPE;
584: lv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
585:
586: cur_unit_atmpt_dis_rec cur_unit_atmpt_dis%ROWTYPE;
587: cur_term_cal_rec cur_term_cal%ROWTYPE;