Operation Details
Description: Returns child organization units for specified parent organization unit for a specified org structure.
Sterotype: nsmulti
SQL 
SELECT
  OrganisationUnit.organisationUnitID,
  OrganisationUnit.name,
  OrgUnitParentLink.organisationStructureID
INTO
  :elementID,
  :elementName,
  :organisationStructureID 
FROM
  OrganisationUnit,
  OrgUnitParentLink 
WHERE OrgUnitParentLink.organisationStructureID = :organisationStructureID 
  AND OrgUnitParentLink.parentOrganisationUnitID = :organisationUnitID 
  AND OrganisationUnit.organisationUnitID = OrgUnitParentLink.organisationUnitID 
  AND OrganisationUnit.recordStatus = :recordStatus