DPL-047 Use stored procedure to retrieve destination plate information

User story
As a development team we would like to change how we query the DART database to retrieve the destination plate information. We are using currently using a view but the view is not operating efficiently and can lead to blocking issues. A stored procedure should operate most efficiently and provide the same, required output.

Who are the primary contacts for this story
@pjvv
@andrewsparkes

Acceptance criteria
To be considered successful the solution must allow:

• call a stored procedure instead of the view

Dependencies
This story is blocked by the following dependencies:

• #<issue_no.>
• sanger/#<issue_no.>

References
This story has a non-blocking relationship with:

• #<issue_no.>
• sanger/#<issue_no.>

Additional context
Yann will be assisting from the DBA team to convert the view to a stored procedure and help us optimise the interactions between LIMS and SQL Server.

No files or tests are named. Start by locating the Lighthouse code that retrieves destination plate information through the current view and review its SQL Server interaction; confirm the stored procedure returns the same required output and that the query path calls it instead of the view.