Add HQL and named query for listing active or occupied locations;
Add HQL for getting available detention location type in a city.