Thanks Hube
I discovered more issues with the current insulation work in the joists so I think I'm going to go with the spray foam in this area. However, I still want to use batt insulation and a vapour barrier for my walls. This is where I'm not sure if I can use spray foam in the joists...