APPS.IGS_EN_ENROLL_WLST dependencies on IGS_PS_UNIT_VER

Line 53: FROM igs_ps_unit_ver uv,

49: CURSOR unit_ver_min_pts_cur
50: IS
51: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points),
52: uv.points_override_ind
53: FROM igs_ps_unit_ver uv,
54: igs_ps_usec_cps cps,
55: igs_ps_unit_ofr_opt uoo
56: WHERE uoo.uoo_id = cps.uoo_id(+) AND
57: uoo.unit_cd = uv.unit_cd AND

Line 70: lv_enrolled_credit_points igs_ps_unit_ver.enrolled_credit_points%TYPE;

66:
67: lv_rec_ind NUMBER;
68: lv_enrolled_yn VARCHAR2(1);
69: lv_minimum_credit_points igs_ps_usec_cps.minimum_credit_points%TYPE;
70: lv_enrolled_credit_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
71: lv_points_override_ind igs_ps_unit_ver.points_override_ind%TYPE;
72: l_exp_err VARCHAR2(2000);
73:
74: CURSOR c_find_person_no

Line 71: lv_points_override_ind igs_ps_unit_ver.points_override_ind%TYPE;

67: lv_rec_ind NUMBER;
68: lv_enrolled_yn VARCHAR2(1);
69: lv_minimum_credit_points igs_ps_usec_cps.minimum_credit_points%TYPE;
70: lv_enrolled_credit_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
71: lv_points_override_ind igs_ps_unit_ver.points_override_ind%TYPE;
72: l_exp_err VARCHAR2(2000);
73:
74: CURSOR c_find_person_no
75: IS

Line 800: igs_ps_unit_ver uv

796: WHERE cal_type = p_cal_type AND
797: closed_flag = 'N' AND
798: org_unit_cd = (SELECT NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd)
799: FROM igs_ps_unit_ofr_opt uoo,
800: igs_ps_unit_ver uv
801: WHERE uoo.uoo_id = p_uoo_id AND
802: uv.unit_cd = uoo.unit_cd AND
803: uv.version_number = uoo.version_number);
804: CURSOR c_incl_inst_wlst_cp is

Line 1447: igs_ps_unit_ver uv,

1443: CURSOR igs_ps_usec_lim_wlst_cur IS
1444: SELECT NVL (usec.enrollment_maximum, NVL(uv.enrollment_maximum,9999) ) enrollment_maximum,
1445: usec.max_students_per_waitlist
1446: FROM igs_ps_usec_lim_wlst usec,
1447: igs_ps_unit_ver uv,
1448: igs_ps_unit_ofr_opt uoo
1449: WHERE uoo.unit_cd = uv.unit_cd
1450: AND uoo.version_number = uv.version_number
1451: AND uoo.uoo_id = usec.uoo_id (+)