APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_PS_UNIT_VER_ALL

Line 26: v_repeatable_ind igs_ps_unit_ver_all.repeatable_ind%TYPE;

22: -- leaving the uoo_id NULL and providing the other parameters.
23: -------------------------------------------------------------------------------
24: DECLARE
25: gv_other_detail VARCHAR2 (255);
26: v_repeatable_ind igs_ps_unit_ver_all.repeatable_ind%TYPE;
27: v_use_most_recent_unit_attempt igs_en_rep_process.use_most_recent_unit_attempt%TYPE;
28: v_use_best_grade_attempt igs_en_rep_process.use_best_grade_attempt%TYPE;
29: v_external_formula igs_en_rep_process.external_formula%TYPE;
30: v_new_outcome_dt DATE;

Line 45: igs_ps_unit_ver_all uv,

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
49: AND uoo.unit_cd = uv.unit_cd

Line 60: igs_ps_unit_ver_all uv1,

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
64: AND uoo1.version_number = uv1.version_number