APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_PS_USEC_LIM_WLST

Line 3353: AND NOT EXISTS (SELECT 'X' FROM igs_ps_usec_lim_wlst ulw WHERE ulw.uoo_id = us.uoo_id);

3349: AND uso.no_set_day_ind ='N'
3350: AND us.unit_section_status <> 'NOT_OFFERED'
3351: AND us.unit_cd =cp_unit_cd
3352: AND us.version_number =cp_version_number
3353: AND NOT EXISTS (SELECT 'X' FROM igs_ps_usec_lim_wlst ulw WHERE ulw.uoo_id = us.uoo_id);
3354:
3355: CURSOR c_title(cp_unit_cd VARCHAR2, cp_version_number NUMBER) IS
3356: SELECT a.*,a.rowid
3357: FROM igs_ps_usec_ref a ,