Operation Details
Description: Count to check if the user holds the position.
Sterotype: ns
SQL 
SELECT
  COUNT (*)
INTO
  :numberOfRecords 
FROM
  Users 
WHERE Users.userName = :userName 
  AND Users.userName IN 
  ( 
  SELECT
    Users.userName 
  FROM
    Users,
    PositionHolderLink 
  WHERE PositionHolderLink.organisationStructureID = :organisationStructureID 
    AND PositionHolderLink.positionID = :positionID 
    AND Users.userName = PositionHolderLink.userName 
    AND PositionHolderLink.recordStatus = :recordStatus 
  )