Operation Details |
Description: | Returns all users that are assigned to the position |
Sterotype: | nsmulti |
SQL |
SELECT Users.fullName, Users.userName INTO :elementName, :userName FROM Users, PositionHolderLink WHERE PositionHolderLink.organisationStructureID = :organisationStructureID AND PositionHolderLink.positionID = :positionID AND Users.userName = PositionHolderLink.userName AND PositionHolderLink.recordStatus = :recordStatus |