APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_USEC_WLST_PRI

Line 2201: FROM igs_ps_usec_wlst_pri

2197: l_n_count_msg NUMBER(6);
2198:
2199: CURSOR c_usec_wlstpric_ser(cp_uoo_id NUMBER) IS
2200: SELECT priority_number
2201: FROM igs_ps_usec_wlst_pri
2202: WHERE uoo_id=cp_uoo_id
2203: ORDER BY priority_number;
2204:
2205: CURSOR cur_priority_id(cp_uoo_id NUMBER) IS

Line 2207: FROM igs_ps_usec_wlst_pri

2203: ORDER BY priority_number;
2204:
2205: CURSOR cur_priority_id(cp_uoo_id NUMBER) IS
2206: SELECT unit_sec_waitlist_priority_id,priority_value
2207: FROM igs_ps_usec_wlst_pri
2208: WHERE uoo_id=cp_uoo_id;
2209:
2210: CURSOR c_usec_wlstprfc_ser(cp_waitlist_priority_id NUMBER) IS
2211: SELECT preference_order