Database SQL Operation: OrganisationUnit.searchChildPositions
Description: | Returns all child positions for an organization unit |
Sterotype: | nsmulti |
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
|