Database SQL Operation: CaseParticipantRole.searchActiveByCaseID1
Description: | Returns active Case Participant Roles that match the caseID. |
Sterotype: | nsmulti |
SELECT
CaseParticipantRole.typeCode,
ConcernRole.concernRoleName,
CaseParticipantRole.participantRoleID
INTO
:typeCode,
:concernRoleName,
:participantRoleID
FROM
CaseParticipantRole,
ConcernRole
WHERE CaseParticipantRole.caseID = :caseID
AND CaseParticipantRole.recordStatus = :recordStatus
AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID
|