APPS.IGS_AS_DERIVE_GRADE dependencies on IGS_AS_GRD_SCH_GRADE

Line 29: FROM igs_as_grd_sch_grade

25: ) IS
26: SELECT grade,
27: lower_mark_range,
28: upper_mark_range
29: FROM igs_as_grd_sch_grade
30: WHERE grading_schema_cd = cp_grading_schema_cd
31: AND version_number = cp_version_number
32: AND s_result_type IN ('FAIL', 'PASS')
33: AND NVL (admin_only_ind, 'N') <> 'Y'

Line 357: FROM igs_as_grd_sch_grade

353: (SELECT grading_schema_cd,
354: version_number,
355: MIN (lower_mark_range) lower_limit,
356: MAX (upper_mark_range) upper_limit
357: FROM igs_as_grd_sch_grade
358: GROUP BY grading_schema_cd,
359: version_number) gslu
360: WHERE suag.person_id = cp_person_id
361: AND suag.course_cd = cp_course_cd

Line 398: FROM igs_as_grd_sch_grade

394: (SELECT grading_schema_cd,
395: version_number,
396: MIN (lower_mark_range) lower_limit,
397: MAX (upper_mark_range) upper_limit
398: FROM igs_as_grd_sch_grade
399: GROUP BY grading_schema_cd,
400: version_number) gslu
401: WHERE usgs.uoo_id = cp_uoo_id
402: AND usgs.default_flag = 'Y'

Line 422: FROM igs_as_grd_sch_grade

418: (SELECT grading_schema_cd,
419: version_number,
420: MIN (lower_mark_range) lower_limit,
421: MAX (upper_mark_range) upper_limit
422: FROM igs_as_grd_sch_grade
423: GROUP BY grading_schema_cd,
424: version_number) gslu
425: WHERE uoo.uoo_id = cp_uoo_id
426: AND ugs.unit_code = uoo.unit_cd

Line 441: FROM igs_as_grd_sch_grade

437: cp_mark IN NUMBER
438: ) IS
439: SELECT grade,
440: s_result_type
441: FROM igs_as_grd_sch_grade
442: WHERE grading_schema_cd = cp_grading_schema_code
443: AND version_number = cp_grading_schema_version
444: AND cp_mark BETWEEN lower_mark_range AND upper_mark_range;
445: --