1526: WHERE CAL_TYPE = p_acad_cal_type AND
1527: sequence_number = p_acad_ci_sequence_number;
1528: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1529: SELECT 'x'
1530: FROM dual
1531: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1532: p_person_id,
1533: p_course_cd,
1534: p_include_fail_grade_ind,
1693: WHERE CAL_TYPE = p_acad_cal_type AND
1694: sequence_number = p_acad_ci_sequence_number;
1695: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1696: SELECT 'x'
1697: FROM dual
1698: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1699: p_person_id,
1700: p_course_cd,
1701: p_include_fail_grade_ind,
1872: WHERE CAL_TYPE = p_acad_cal_type AND
1873: sequence_number = p_acad_ci_sequence_number;
1874: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1875: SELECT 'x'
1876: FROM dual
1877: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1878: p_person_id,
1879: p_course_cd,
1880: p_include_fail_grade_ind,