Operation Details
Description: A method to return a list of assistance units based on the case id and the unit type. The returned is ordered by the unit id.
Sterotype: nsmulti
SQL
SELECT
  assistanceUnitID,
  unitID,
  caseParticipantRoleID
INTO
  :assistanceUnitID,
  :unitID,
  :caseParticipantRoleID 
FROM
  ISPAssistanceUnitProc 
WHERE ISPAssistanceUnitProc.caseID = :caseID 
  AND ISPAssistanceUnitProc.assistanceUnitType = :assistanceUnitType 
ORDER BY ISPAssistanceUnitProc.unitID