DBA Data[Home] [Help]

APPS.IGS_AS_DERIVE_GRADE dependencies on IGS_PS_UNIT_GRD_SCHM

Line 131: FROM igs_ps_unit_grd_schm ugs,

127: cp_uoo_id IN NUMBER
128: ) IS
129: SELECT ugs.grading_schema_code,
130: ugs.grd_schm_version_number
131: FROM igs_ps_unit_grd_schm ugs,
132: igs_ps_unit_ofr_opt_all uoo
133: WHERE uoo.uoo_id = cp_uoo_id
134: AND ugs.unit_code = uoo.unit_cd
135: AND ugs.unit_version_number = uoo.version_number

Line 416: FROM igs_ps_unit_grd_schm ugs,

412: SELECT ugs.grading_schema_code,
413: ugs.grd_schm_version_number,
414: gslu.lower_limit,
415: gslu.upper_limit
416: FROM igs_ps_unit_grd_schm ugs,
417: igs_ps_unit_ofr_opt_all uoo,
418: (SELECT grading_schema_cd,
419: version_number,
420: MIN (lower_mark_range) lower_limit,