1174: -- smaddali Modifed cursor to fetch funding_source for hefd208 build , bug#2717751
1175: CURSOR c_get_crse
1176: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1177: p_crv_version_number igs_he_st_spa.version_number%TYPE,
1178: p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
1179: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
1180: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
1181: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
1182: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
1175: CURSOR c_get_crse
1176: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1177: p_crv_version_number igs_he_st_spa.version_number%TYPE,
1178: p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
1179: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
1180: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
1181: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
1182: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
1183: p_us_version_number igs_he_poous_all.us_version_number%TYPE)
1176: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1177: p_crv_version_number igs_he_st_spa.version_number%TYPE,
1178: p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
1179: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
1180: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
1181: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
1182: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
1183: p_us_version_number igs_he_poous_all.us_version_number%TYPE)
1184: IS
1177: p_crv_version_number igs_he_st_spa.version_number%TYPE,
1178: p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
1179: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
1180: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
1181: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
1182: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
1183: p_us_version_number igs_he_poous_all.us_version_number%TYPE)
1184: IS
1185: SELECT crv.title,