1459: --
1460: CURSOR c_calendar IS
1461: SELECT cal_type,
1462: ci_sequence_number
1463: FROM igs_ps_unit_ofr_opt
1464: WHERE uoo_id = p_uoo_id;
1465: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE DEFAULT NULL;
1466: l_seq_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE DEFAULT NULL;
1467:
1461: SELECT cal_type,
1462: ci_sequence_number
1463: FROM igs_ps_unit_ofr_opt
1464: WHERE uoo_id = p_uoo_id;
1465: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE DEFAULT NULL;
1466: l_seq_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE DEFAULT NULL;
1467:
1468: --
1469: -- cursor to fetch load cal type and load seq number based on teach cal type and teach seq number
1462: ci_sequence_number
1463: FROM igs_ps_unit_ofr_opt
1464: WHERE uoo_id = p_uoo_id;
1465: l_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE DEFAULT NULL;
1466: l_seq_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE DEFAULT NULL;
1467:
1468: --
1469: -- cursor to fetch load cal type and load seq number based on teach cal type and teach seq number
1470: --