SELECT
  DISTINCT Location.name,
  Location.locationStatus
INTO
  :locationName,
  :locationStatus 
FROM
  Location,
  OrganisationUnit,
  OrgUnitPositionLink,
  Position,
  PositionLocationLink,
  OrgUnitParentLink 
WHERE OrgUnitPositionLink.organisationStructureID = :organisationStructureID 
  AND OrgUnitPositionLink.organisationUnitID =OrganisationUnit.organisationUnitID 
  AND OrgUnitPositionLink.positionID =Position.positionID 
  AND PositionLocationLink.locationID =Location.locationID 
  AND PositionLocationLink.positionID =Position.positionID 
  AND OrgUnitPositionLink.organisationStructureID =OrgUnitParentLink.organisationStructureID 
  AND OrgUnitPositionLink.organisationUnitID =OrgUnitParentLink.organisationUnitID 
  AND OrgUnitPositionLink.organisationUnitID = :organisationUnitID