APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PS_USEC_GRD_SCHM

Line 25: FROM igs_ps_usec_grd_schm

21: -- cursor to find the default grading schema at Unit section level. Note that only one
22: -- grading schema can exist as a default grading schema for a Unit offering/ Unit version.
23: CURSOR ger_grd_schm_usec IS
24: SELECT grading_schema_code , grd_schm_version_number
25: FROM igs_ps_usec_grd_schm
26: WHERE uoo_id = p_uoo_id AND
27: default_flag = 'Y' ;
28:
29: --

Line 47: l_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE;

43: WHERE grading_schema_cd = p_outcome_grading_schema_code AND
44: version_number = p_outcome_gs_version_number AND
45: grade = p_grade;
46:
47: l_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE;
48: l_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE;
49: l_dummy VARCHAR2(2) := NULL;
50:
51: BEGIN

Line 48: l_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE;

44: version_number = p_outcome_gs_version_number AND
45: grade = p_grade;
46:
47: l_grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%TYPE;
48: l_grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%TYPE;
49: l_dummy VARCHAR2(2) := NULL;
50:
51: BEGIN
52:

Line 439: FROM IGS_PS_USEC_GRD_SCHM

435: --
436: -- cursor to check if the Grading Schema has been defined at the Unit section level
437: CURSOR val_usec IS
438: SELECT 'x'
439: FROM IGS_PS_USEC_GRD_SCHM
440: WHERE uoo_id = p_uoo_id AND
441: grading_schema_code = p_grading_schema_code AND
442: grd_schm_version_number = p_gs_version_number;
443: