128: ) IS
129: SELECT ugs.grading_schema_code,
130: ugs.grd_schm_version_number
131: FROM igs_ps_unit_grd_schm ugs,
132: igs_ps_unit_ofr_opt_all uoo
133: WHERE uoo.uoo_id = cp_uoo_id
134: AND ugs.unit_code = uoo.unit_cd
135: AND ugs.unit_version_number = uoo.version_number
136: AND ugs.default_flag = 'Y';
413: ugs.grd_schm_version_number,
414: gslu.lower_limit,
415: gslu.upper_limit
416: FROM igs_ps_unit_grd_schm ugs,
417: igs_ps_unit_ofr_opt_all uoo,
418: (SELECT grading_schema_cd,
419: version_number,
420: MIN (lower_mark_range) lower_limit,
421: MAX (upper_mark_range) upper_limit
1723: cp_uoo_id IN NUMBER
1724: ) IS
1725: SELECT start_dt
1726: FROM igs_ca_inst ci,
1727: igs_ps_unit_ofr_opt_all uoo
1728: WHERE uoo.cal_type = ci.cal_type
1729: AND ci.sequence_number = uoo.ci_sequence_number
1730: AND uoo.uoo_id = cp_uoo_id;
1731: --