SELECT
  Employer.primaryAlternateID,
  Employer.concernRoleID,
  Employer.tradingName,
  Employer.registeredName,
  ConcernRole.sensitivity,
  addressLine1.elementValue,
  city.elementValue
INTO
  :primaryAlternateID,
  :concernRoleID,
  :tradingName,
  :registeredName,
  :sensitivity,
  :addressLine1,
  :city 
FROM
  Employer,
  ConcernRole,
  AddressElement addressLine1,
  AddressElement city 
WHERE 
  (
    :searchByTradingName = '0' 
    OR Employer.upperTradingName like :tradingName 
  ) 
  AND 
  (
    :searchByRegisteredName = '0' 
    OR Employer.upperRegisteredName like :registeredName 
  ) 
  AND ConcernRole.concernRoleID = Employer.concernRoleID 
  AND addressLine1.addressID = ConcernRole.primaryAddressID 
  AND addressLine1.elementType = :addressLine1Type 
  AND city.addressID = ConcernRole.primaryAddressID 
  AND city.elementType = :cityType 
  AND 
  (
    :searchByAddressLine1 = '0' 
    OR addressLine1.upperElementValue like :addressLine1 
  ) 
  AND 
  (
    :searchByCity = '0' 
    OR city.upperElementValue like :city 
  )