APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_EXCEPTIONS

Line 10967: FROM wsh_exceptions

10963: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'check_exception';
10964:
10965: CURSOR c_check_exception (p_delivery_id in number) IS
10966: SELECT severity, delivery_id, exception_id
10967: FROM wsh_exceptions
10968: WHERE delivery_id = p_delivery_id
10969: AND status not in ('NOT_HANDLED' , 'NO_ACTION_REQUIRED' , 'CLOSED')
10970: ORDER BY decode (severity, 'HIGH', 1,
10971: 'MEDIUM', 2,