DBA Data[Home] [Help]

APPS.IGS_AS_DERIVE_GRADE dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 132: igs_ps_unit_ofr_opt_all uoo

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
136: AND ugs.default_flag = 'Y';

Line 417: igs_ps_unit_ofr_opt_all uoo,

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,
421: MAX (upper_mark_range) upper_limit

Line 1727: igs_ps_unit_ofr_opt_all uoo

1723: cp_uoo_id IN NUMBER
1724: ) IS
1725: SELECT start_dt
1726: FROM igs_ca_inst ci,
1727: igs_ps_unit_ofr_opt_all uoo
1728: WHERE uoo.cal_type = ci.cal_type
1729: AND ci.sequence_number = uoo.ci_sequence_number
1730: AND uoo.uoo_id = cp_uoo_id;
1731: --