622: SELECT ai.ass_id,
623: gs.grading_schema_cd,
624: gs.version_number
625: FROM igs_as_assessmnt_itm ai,
626: igs_as_grd_schema gs
627: WHERE (ai.assessment_type = p_assessment_type
628: OR p_assessment_type IS NULL
629: )
630: AND (ai.ass_id = p_ass_id
737: --
738: --
739: --
740: CURSOR c_grade_invalid (
741: cp_grading_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE,
742: cp_gs_version_number igs_as_grd_schema.version_number%TYPE
743: ) IS
744: SELECT gsg.lower_mark_range,
745: gsg.upper_mark_range
738: --
739: --
740: CURSOR c_grade_invalid (
741: cp_grading_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE,
742: cp_gs_version_number igs_as_grd_schema.version_number%TYPE
743: ) IS
744: SELECT gsg.lower_mark_range,
745: gsg.upper_mark_range
746: FROM igs_as_grd_sch_grade gsg