APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 746: FROM igs_as_grd_sch_grade gsg

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
747: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
748: AND gsg.version_number = cp_gs_version_number
749: AND system_only_ind = 'N'
750: AND gsg.grade = p_grade;

Line 764: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,

760: --
761: -- Derive the Grade from the Grading Schema and the entered mark
762: --
763: CURSOR cur_gsg_derive (
764: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
765: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
766: ) IS
767: SELECT gsg.grade
768: FROM igs_as_grd_sch_grade gsg

Line 765: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE

761: -- Derive the Grade from the Grading Schema and the entered mark
762: --
763: CURSOR cur_gsg_derive (
764: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
765: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
766: ) IS
767: SELECT gsg.grade
768: FROM igs_as_grd_sch_grade gsg
769: WHERE gsg.grading_schema_cd = cp_grading_schema_cd

Line 768: FROM igs_as_grd_sch_grade gsg

764: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,
765: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE
766: ) IS
767: SELECT gsg.grade
768: FROM igs_as_grd_sch_grade gsg
769: WHERE gsg.grading_schema_cd = cp_grading_schema_cd
770: AND gsg.version_number = cp_gs_version_number
771: AND gsg.system_only_ind = 'N'
772: AND p_mark BETWEEN lower_mark_range AND upper_mark_range + 0.999;