modified views for the store procedure