Operation Details
Description: Method to return a list of positions found by position name. Search is performed based on partial match of the name criteria.
Sterotype: nsmulti
SQL 
SELECT
  Position.positionID,
  Position.name,
  OrgUnitPositionLink.organisationUnitID,
  OrganisationUnit.name
INTO
  :positionID,
  :name,
  :organisationUnitID,
  :organisationUnitName 
FROM
  Position,
  OrganisationStructure,
  OrgUnitPositionLink,
  OrganisationUnit 
WHERE 
  (
    UPPER(Position.name) LIKE :name 
  ) 
  AND 
  (
    
    (
      OrgUnitPositionLink.organisationUnitID = OrganisationUnit.organisationUnitID 
    ) 
    AND 
    (
      OrgUnitPositionLink.positionID = Position.positionID 
    ) 
  ) 
  AND 
  (
    
    (
      OrganisationStructure.organisationStructureID = :organisationStructureID 
    ) 
    AND 
    (
      OrganisationStructure.organisationStructureID = OrgUnitPositionLink.organisationStructureID 
    ) 
  ) 
  AND Position.recordStatus = :recordStatus