SELECT
  DISTINCT Position.positionID
INTO
  :positionID 
FROM
  Position,
  PositionHolderLink,
  OrgUnitPositionLink 
WHERE 
  (
    
    (
      Position.positionID = PositionHolderLink.positionID 
    ) 
    AND 
    (
      Position.positionID = OrgUnitPositionLink.positionID 
    ) 
  ) 
  AND PositionHolderLink.organisationStructureID = :organisationStructureID 
  AND PositionHolderLink.recordStatus = :recordStatus 
  AND PositionHolderLink.fromDate <= :effectiveDate 
  AND 
  (
    PositionHolderLink.toDate >= :effectiveDate 
    OR PositionHolderLink.toDate IS NULL 
  )