APPS.IGS_EN_TIMESLOTS dependencies on IGS_PS_UNIT_OFR_OPT

Line 322: CURSOR cur_enrolled_cp (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

318: sua.ci_sequence_number = carel.sub_ci_sequence_number and
319: carel.sup_cal_type = p_cal_type and
320: carel.sup_ci_sequence_number = p_sequence_number));
321:
322: CURSOR cur_enrolled_cp (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
323: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
324: FROM igs_ps_unit_ver uv ,
325: igs_ps_usec_cps cps ,
326: igs_ps_unit_ofr_opt uoo

Line 326: igs_ps_unit_ofr_opt uoo

322: CURSOR cur_enrolled_cp (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
323: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
324: FROM igs_ps_unit_ver uv ,
325: igs_ps_usec_cps cps ,
326: igs_ps_unit_ofr_opt uoo
327: WHERE
328: uoo.uoo_id = cps.uoo_id(+) AND
329: uoo.unit_cd = uv.unit_cd AND
330: uoo.version_number = uv.version_number AND