DBA Data[Home] [Help]

APPS.IGS_AS_DERIVE_GRADE dependencies on IGS_PS_USEC_GRD_SCHM

Line 119: FROM igs_ps_usec_grd_schm

115: cp_uoo_id IN NUMBER
116: ) IS
117: SELECT grading_schema_code,
118: grd_schm_version_number
119: FROM igs_ps_usec_grd_schm
120: WHERE uoo_id = cp_uoo_id
121: AND default_flag = 'Y';
122: --
123: -- Cursor to get the default Grading Schema for the Unit if default Grading

Line 393: FROM igs_ps_usec_grd_schm usgs,

389: SELECT usgs.grading_schema_code,
390: usgs.grd_schm_version_number,
391: gslu.lower_limit,
392: gslu.upper_limit
393: FROM igs_ps_usec_grd_schm usgs,
394: (SELECT grading_schema_cd,
395: version_number,
396: MIN (lower_mark_range) lower_limit,
397: MAX (upper_mark_range) upper_limit