1539: AND us.version_number = cp_us_version_number;
1540:
1541:
1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1540:
1541:
1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1541:
1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1551: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS