Database SQL Operation: ISPAssistanceUnitProc.searchByCaseIDAndUnitType
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 |
SELECT
assistanceUnitID,
unitID,
caseParticipantRoleID
INTO
:assistanceUnitID,
:unitID,
:caseParticipantRoleID
FROM
ISPAssistanceUnitProc
WHERE ISPAssistanceUnitProc.caseID = :caseID
AND ISPAssistanceUnitProc.assistanceUnitType = :assistanceUnitType
ORDER BY ISPAssistanceUnitProc.unitID
|