APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_USEC_LIM_WLST

Line 121: FROM igs_ps_usec_lim_wlst usec,

117:
118: -- Cursor to select the number of auditors for the given unit
119: CURSOR c_usec_audit_lim IS
120: SELECT NVL (usec.max_auditors_allowed, NVL(uv.max_auditors_allowed,999999) )
121: FROM igs_ps_usec_lim_wlst usec,
122: igs_ps_unit_ver uv,
123: igs_ps_unit_ofr_opt uoo
124: WHERE uoo.unit_cd = uv.unit_cd
125: AND uoo.version_number = uv.version_number

Line 3468: FROM igs_ps_usec_lim_wlst

3464:
3465: -- cursor to get the enrollment maximum defined at unit section level
3466: CURSOR cur_usec_enr_max IS
3467: SELECT enrollment_maximum
3468: FROM igs_ps_usec_lim_wlst
3469: WHERE uoo_id = p_uoo_id;
3470:
3471: -- cursor to get the enrollment maximum defined at unit level
3472: CURSOR cur_unit_enr_max IS

Line 3494: l_enrollment_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;

3490: FOR UPDATE ; -- p_uoo_id is parameter of container function
3491:
3492: cur_rsv_ext_rec cur_rsv_ext%ROWTYPE;
3493:
3494: l_enrollment_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
3495: l_resereved_max NUMBER;
3496: l_rowid VARCHAR2(25);
3497: l_rsv_ext_id NUMBER;
3498: l_rsv_temp_id NUMBER;