DBA Data[Home] [Help]

APPS.IGS_EN_ENROLL_WLST dependencies on IGS_PS_USEC_CPS

Line 54: igs_ps_usec_cps cps,

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
58: uoo.version_number = uv.version_number AND

Line 64: FROM igs_ps_usec_cps

60:
61: CURSOR usec_min_pts_cur
62: IS
63: SELECT minimum_credit_points
64: FROM igs_ps_usec_cps
65: WHERE uoo_id = p_uoo_id;
66:
67: lv_rec_ind NUMBER;
68: lv_enrolled_yn VARCHAR2(1);

Line 69: lv_minimum_credit_points igs_ps_usec_cps.minimum_credit_points%TYPE;

65: WHERE uoo_id = p_uoo_id;
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: