My belief is that software providers don't like stored procedures because they enable DBAs and developers to see what the system is doing. All our inhouse developments use stored procedures - in addition to the performance implications they can make testing easier and they can be reused.