SELECT
  AlternateName.firstForename,
  AlternateName.surname,
  Person.dateOfBirth,
  Person.gender,
  Person.personBirthName,
  Person.motherBirthSurname,
  Person.primaryAlternateID,
  Person.concernRoleID,
  ConcernRole.sensitivity,
  city.elementValue,
  addressLine1.elementValue
INTO
  :firstForename,
  :surname,
  :dateOfBirth,
  :gender,
  :personBirthName,
  :motherBirthSurname,
  :primaryAlternateID,
  :concernRoleID,
  :sensitivity,
  :city,
  :addressLine1 
FROM
  Person,
  ConcernRole,
  AlternateName,
  AddressElement city,
  AddressElement addressLine1 
WHERE ConcernRole.concernRoleID IN 
  ( 
  SELECT
    concernRoleID 
  FROM
    concernRoleAlternateID 
  WHERE concernRoleAlternateID.alternateID = :primaryAlternateID 
  ) 
  AND Person.concernRoleID = ConcernRole.concernRoleID 
  AND Person.primaryAlternateNameID = AlternateName.alternateNameID 
  AND 
  (
    city.addressID = ConcernRole.primaryAddressID 
    AND city.elementType = :cityType 
  ) 
  AND 
  (
    addressLine1.addressID = ConcernRole.primaryAddressID 
    AND addressLine1.elementType = :addressLine1Type 
  )