APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 44: FROM igs_ps_unit_ofr_opt_all uoo,

40: SELECT uv.repeatable_ind,
41: rp_org.use_most_recent_unit_attempt,
42: rp_org.use_best_grade_attempt,
43: rp_org.external_formula
44: FROM igs_ps_unit_ofr_opt_all uoo,
45: igs_ps_unit_ver_all uv,
46: igs_en_rep_process rp_org,
47: igs_or_inst_org_base_v hp
48: WHERE uoo.uoo_id = p_uoo_id

Line 59: FROM igs_ps_unit_ofr_opt_all uoo1,

55: SELECT uv1.repeatable_ind,
56: rp_inst.use_most_recent_unit_attempt,
57: rp_inst.use_best_grade_attempt,
58: rp_inst.external_formula
59: FROM igs_ps_unit_ofr_opt_all uoo1,
60: igs_ps_unit_ver_all uv1,
61: igs_en_rep_process rp_inst
62: WHERE uoo1.uoo_id = p_uoo_id
63: AND uoo1.unit_cd = uv1.unit_cd

Line 67: FROM igs_ps_unit_ofr_opt_all uoo2,

63: AND uoo1.unit_cd = uv1.unit_cd
64: AND uoo1.version_number = uv1.version_number
65: AND rp_inst.org_unit_id IS NULL
66: AND NOT EXISTS ( SELECT 'X'
67: FROM igs_ps_unit_ofr_opt_all uoo2,
68: igs_en_rep_process rp_org,
69: igs_or_inst_org_base_v hp
70: WHERE uoo1.uoo_id = uoo2.uoo_id
71: AND uoo2.owner_org_unit_cd = hp.party_number