APPS.IGS_EN_GEN_015 dependencies on IGS_PS_UNIT_VER

Line 477: igs_ps_unit_ver uv,

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
481: AND uoo.uoo_id = usec.uoo_id (+)

Line 698: FROM igs_ps_unit_ver

694:
695: -- cursor to fetch the override enrollment maximum value defined at unit level
696: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
697: SELECT override_enrollment_max, enrollment_maximum
698: FROM igs_ps_unit_ver
699: WHERE (unit_cd , version_number ) IN (SELECT unit_cd , version_number
700: FROM igs_ps_unit_ofr_opt
701: WHERE uoo_id = p_uoo_id);
702:

Line 765: l_enrollment_maximum igs_ps_unit_ver.enrollment_maximum%TYPE;

761: AND rsv_seat_ext_id IS NOT NULL;
762:
763: l_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE;
764: l_version_number igs_ps_ver.version_number%TYPE;
765: l_enrollment_maximum igs_ps_unit_ver.enrollment_maximum%TYPE;
766: l_override_enrollment_max igs_ps_unit_ver.override_enrollment_max%TYPE;
767: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
768: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE;
769: l_rsv_allowed VARCHAR2(10);

Line 766: l_override_enrollment_max igs_ps_unit_ver.override_enrollment_max%TYPE;

762:
763: l_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE;
764: l_version_number igs_ps_ver.version_number%TYPE;
765: l_enrollment_maximum igs_ps_unit_ver.enrollment_maximum%TYPE;
766: l_override_enrollment_max igs_ps_unit_ver.override_enrollment_max%TYPE;
767: l_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
768: l_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE;
769: l_rsv_allowed VARCHAR2(10);
770: l_enr_meth_type igs_en_method_type.enr_method_type%TYPE;