Operation Details
Description: Search positions assigned to a given task by task id. Also the method returns required details to load Position home page.
Sterotype: nsmulti
SQL 
SELECT
  p.name,
  p.positionID,
  ost.organisationStructureID,
  ou.organisationUnitID
INTO
  :name,
  :positionID,
  :organisationStructureID,
  :organisationUnitID 
FROM
  TaskAssignment ta,
  Position p,
  OrganisationStructure ost,
  OrganisationUnit ou,
  OrgUnitPositionLink opol 
WHERE p.positionID = ta.relatedID 
  AND opol.positionID = p.positionID 
  AND opol.organisationStructureID = ost.organisationStructureID 
  AND opol.organisationUnitID = ou.organisationUnitID 
  AND ta.assigneeType = :bizObjType 
  AND ou.recordStatus = :recordStatus 
  AND opol.recordStatus = :recordStatus 
  AND p.recordStatus = :recordStatus 
  AND ta.taskID = :taskID