APPS.IGS_EN_NSC_PKG dependencies on IGS_PS_UNIT_OFR_OPT

Line 2797: CURSOR c_unit_cp( cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

2793: AND ut.uoo_id = p_c_uoo_id;
2794: c_sua_rec c_orig_units%ROWTYPE;
2795: --Credit points at the unit level - need to get and compare.
2796:
2797: CURSOR c_unit_cp( cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2798: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)
2799: FROM igs_ps_unit_ver uv,
2800: igs_ps_usec_cps cps,
2801: igs_ps_unit_ofr_opt uoo

Line 2801: igs_ps_unit_ofr_opt uoo

2797: CURSOR c_unit_cp( cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2798: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)
2799: FROM igs_ps_unit_ver uv,
2800: igs_ps_usec_cps cps,
2801: igs_ps_unit_ofr_opt uoo
2802: WHERE uoo.uoo_id = cps.uoo_id(+) AND
2803: uoo.unit_cd = uv.unit_cd AND
2804: uoo.version_number = uv.version_number AND
2805: uoo.uoo_id = cp_uoo_id;

Line 2807: CURSOR c_uv( cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

2803: uoo.unit_cd = uv.unit_cd AND
2804: uoo.version_number = uv.version_number AND
2805: uoo.uoo_id = cp_uoo_id;
2806:
2807: CURSOR c_uv( cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2808: SELECT uoo.version_number
2809: FROM igs_ps_unit_ofr_opt uoo
2810: WHERE uoo.uoo_id = cp_uoo_id;
2811:

Line 2809: FROM igs_ps_unit_ofr_opt uoo

2805: uoo.uoo_id = cp_uoo_id;
2806:
2807: CURSOR c_uv( cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2808: SELECT uoo.version_number
2809: FROM igs_ps_unit_ofr_opt uoo
2810: WHERE uoo.uoo_id = cp_uoo_id;
2811:
2812: l_unit_version NUMBER;
2813: old_load_incur varchar2(1);