[Home] [Help]
2393: ---------------------------
2394: CURSOR cur_ftci(cp_c_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
2395: cp_n_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
2396: SELECT sup_cal_type cal_type, sup_ci_sequence_number sequence_number
2397: FROM igs_ca_inst_rel
2398: WHERE (sub_cal_type,sub_ci_sequence_number) IN (SELECT load_cal_type, load_ci_sequence_number
2399: FROM igs_ca_teach_to_load_v
2400: WHERE teach_cal_type = cp_c_cal_type
2401: AND teach_ci_sequence_number = cp_n_sequence_number);
4509:
4510: /* Cursor to get teaching calendars for respective Academic calendars */
4511:
4512: OPEN c_get_tch_cal FOR 'SELECT cir.sub_cal_type,cir.sub_ci_sequence_number'||
4513: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||
4514: ' WHERE cir.sub_cal_type = ct.cal_type AND'||
4515: ' ct.s_cal_cat = :1 AND'||
4516: ' sup_cal_type = :2 AND'||
4517: ' sup_ci_sequence_number = :3 ' USING l_c_s_cal_cat,p_c_cal_type,p_n_cal_seq_num;
4613:
4614: /* Cursor for to get Academic calendar when Teach cal is passed */
4615:
4616: OPEN c_get_cal FOR 'SELECT cir.sup_cal_type,cir.sup_ci_sequence_number'||
4617: ' FROM igs_ca_inst_rel cir, igs_ca_type ct'||
4618: ' WHERE cir.sup_cal_type = ct.cal_type AND'||
4619: ' ct.s_cal_cat = :1 AND'||
4620: ' sub_cal_type = :2 AND'||
4621: ' sub_ci_sequence_number = :3 ' USING l_c_s_cal_cat,p_c_cal_type,p_n_cal_seq_num;