Actually I tried with Outer Apply but it increased the execution time. Actually that SP is not taking that much time from SSMS but from the application it is little longer.

The dev is saying that we can still implement that query by avoiding that joins. I am in a way to find that