LPS-48301 Adding support to staging and hierarchical sites

Hey Brian,

This pull request enables staging to find an entity in a site hierarchy. The new methods provide the code for looking up the entity if it's missing but also in other cases as well.

Thanks,

Máté