SELECT
  Location.locationID,
  Location.name,
  Location.locationStatus,
  PositionLocationLink.positionLocationLinkID,
  PositionLocationLink.versionNo
INTO
  :locationID,
  :locationName,
  :locationStatus,
  :positionLocationLinkID,
  :versionNo 
FROM
  PositionLocationLink,
  Location 
WHERE PositionLocationLink.positionID = :positionID 
  AND Location.locationID =PositionLocationLink.locationID