Lookup SP based on the ID provided.