Operation Details
Description: Method to return any active position for specified organization structure and position name.
Sterotype: ns
SQL 
SELECT
  Position.positionID
INTO
  :positionID 
FROM
  Position,
  OrgUnitPositionLink 
WHERE UPPER(Position.name) = :name 
  AND OrgUnitPositionLink.organisationStructureID = :organisationStructureID 
  AND Position.positionID = OrgUnitPositionLink.positionID 
  AND Position.recordStatus = :recordStatus