There are a number of performance issues here. I would quote a client 2 days minimum to optimize this one. However what did jump out at me was the excessive lookups from [DB_Staging].[dbo].[EXCPTRNSPF] due to a poor estimation. Make sure stats are up to date on [EXCPTRNSPF].
You might see decent improvements if you can make [idx_EXCPTRNSPF_i_nc_02] covering by including LOBCODE.
