APPS.IGS_EN_GEN_LEGACY dependencies on IGS_PS_UNIT_GRD_SCHM

Line 33: FROM igs_ps_unit_grd_schm

29: --
30: -- cursor to find the default grading schema at Unit version level.
31: CURSOR ger_grd_schm_unit IS
32: SELECT grading_schema_code , grd_schm_version_number
33: FROM igs_ps_unit_grd_schm
34: WHERE unit_code = p_unit_cd AND
35: unit_version_number = p_version_number AND
36: default_flag = 'Y' ;
37:

Line 448: FROM IGS_PS_UNIT_GRD_SCHM

444: --
445: -- cursor to check if the Grading Schema has been defined at the Unit level
446: CURSOR val_unit IS
447: SELECT 'x'
448: FROM IGS_PS_UNIT_GRD_SCHM
449: WHERE unit_code = p_unit_cd AND
450: unit_version_number = p_version_number AND
451: grading_schema_code = p_grading_schema_code AND
452: grd_schm_version_number = p_gs_version_number;