APPS.IGS_EN_GEN_015 dependencies on IGS_PS_USEC_LIM_WLST

Line 476: FROM igs_ps_usec_lim_wlst usec,

472: --
473: CURSOR cur_maximum_enrollment IS
474: SELECT NVL (usec.enrollment_maximum, uv.enrollment_maximum) enrollment_maximum,
475: uoo.enrollment_actual enrollment_actual
476: FROM igs_ps_usec_lim_wlst usec,
477: igs_ps_unit_ver uv,
478: igs_ps_unit_ofr_opt uoo
479: WHERE uoo.unit_cd = uv.unit_cd
480: AND uoo.version_number = uv.version_number

Line 706: FROM igs_ps_usec_lim_wlst

702:
703: -- Cursor to fetch the Override enrollment Maximum value defined at Unit Section level
704: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
705: SELECT override_enrollment_max, enrollment_maximum
706: FROM igs_ps_usec_lim_wlst
707: WHERE uoo_id = p_uoo_id;
708:
709: CURSOR c_prg_ver IS
710: SELECT version_number

Line 818: FROM igs_ps_usec_lim_wlst

814: -- Cursor to Check if Waitlisting is allowed at the unit section level .
815: --
816: CURSOR c_wait_allow_unit_section ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
817: SELECT waitlist_allowed , max_students_per_waitlist
818: FROM igs_ps_usec_lim_wlst
819: WHERE uoo_id = cp_uoo_id ;
820: --
821: -- cursor check if waitlisting is allowed at the unit offering level .
822: --

Line 839: l_waitlist_max igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE;

835: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
836: l_wlst_max_ovr BOOLEAN;
837: l_closed_section_ovr BOOLEAN;
838: l_waitlist_allowed igs_ps_unit_ofr_pat.waitlist_allowed%TYPE ;
839: l_waitlist_max igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE;
840:
841: BEGIN
842:
843: --