APPS.IGS_EN_SUA_API dependencies on IGS_PS_USEC_LIM_WLST_V

Line 81: SELECT max_students_per_waitlist FROM igs_ps_usec_lim_wlst_v

77: --
78: -- The following three cursors added as part of the bug 2375362. pmarada
79: -- getting maximum students per waitlist in the unit section level.
80: CURSOR c_max_std_per_wait_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
81: SELECT max_students_per_waitlist FROM igs_ps_usec_lim_wlst_v
82: WHERE uoo_id = cp_uoo_id;
83: l_max_std_per_wait_usec igs_ps_usec_lim_wlst_v.max_students_per_waitlist%TYPE;
84:
85: -- Getting the maximum students per waitlist from unit offering pattern level.

Line 83: l_max_std_per_wait_usec igs_ps_usec_lim_wlst_v.max_students_per_waitlist%TYPE;

79: -- getting maximum students per waitlist in the unit section level.
80: CURSOR c_max_std_per_wait_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
81: SELECT max_students_per_waitlist FROM igs_ps_usec_lim_wlst_v
82: WHERE uoo_id = cp_uoo_id;
83: l_max_std_per_wait_usec igs_ps_usec_lim_wlst_v.max_students_per_waitlist%TYPE;
84:
85: -- Getting the maximum students per waitlist from unit offering pattern level.
86: CURSOR c_max_std_per_wait_uofr_pat (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
87: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,