Operation Details
Description: Returns all child positions for an organization unit
Sterotype: nsmulti
SQL
SELECT
  Position.positionID,
  Position.name,
  OrgUnitPositionLink.organisationStructureID
INTO
  :elementID,
  :elementName,
  :organisationStructureID 
FROM
  OrgUnitPositionLink,
  Position 
WHERE OrgUnitPositionLink.organisationStructureID = :organisationStructureID 
  AND OrgUnitPositionLink.organisationUnitID = :organisationUnitID 
  AND Position.positionID = OrgUnitPositionLink.positionID 
  AND Position.recordStatus = :recordStatus