APPS.IGS_AS_VAL_SUAO dependencies on IGS_AS_GRD_SCH_GRADE

Line 345: v_lower_mark_range igs_as_grd_sch_grade.lower_mark_range%TYPE;

341: p_message_name OUT NOCOPY VARCHAR2
342: ) RETURN BOOLEAN IS
343: --
344: gv_other_detail VARCHAR2 (255);
345: v_lower_mark_range igs_as_grd_sch_grade.lower_mark_range%TYPE;
346: v_upper_mark_range igs_as_grd_sch_grade.upper_mark_range%TYPE;
347: --
348: -- Get the Lower and Upper Mark limits of the Grade as setup in the
349: -- Grading Schema

Line 346: v_upper_mark_range igs_as_grd_sch_grade.upper_mark_range%TYPE;

342: ) RETURN BOOLEAN IS
343: --
344: gv_other_detail VARCHAR2 (255);
345: v_lower_mark_range igs_as_grd_sch_grade.lower_mark_range%TYPE;
346: v_upper_mark_range igs_as_grd_sch_grade.upper_mark_range%TYPE;
347: --
348: -- Get the Lower and Upper Mark limits of the Grade as setup in the
349: -- Grading Schema
350: --

Line 354: FROM igs_as_grd_sch_grade gsg

350: --
351: CURSOR c_gsg IS
352: SELECT gsg.lower_mark_range,
353: gsg.upper_mark_range
354: FROM igs_as_grd_sch_grade gsg
355: WHERE gsg.grading_schema_cd = p_grading_schema_cd
356: AND gsg.version_number = p_version_number
357: AND gsg.grade = p_grade;
358: --

Line 365: FROM igs_as_grd_sch_grade gsg

361: --
362: CURSOR c_gsg_min_max IS
363: SELECT NVL (MIN (gsg.lower_mark_range), 0) min_lower_mark_range,
364: NVL (MAX (gsg.upper_mark_range), 1000) max_upper_mark_range
365: FROM igs_as_grd_sch_grade gsg
366: WHERE gsg.grading_schema_cd = p_grading_schema_cd
367: AND gsg.version_number = p_version_number;
368: rec_gsg_min_max c_gsg_min_max%ROWTYPE;
369: BEGIN