Database SQL Operation: ResourceTransfer.readResourceTransferOwnerDetails
Description: | Reads the primary owner details of the resource transfer. |
Sterotype: | ns |
SELECT
ResourceTransfer.caseParticipantRoleID,
ConcernRole.concernRoleName,
CaseParticipantRole.participantRoleID
INTO
:ownerCaseParticipantRoleID,
:ownerName,
:participantRoleID
FROM
ResourceTransfer,
CaseParticipantRole,
ConcernRole
WHERE ResourceTransfer.evidenceID = :evidenceID
AND CaseParticipantRole.caseParticipantRoleID = ResourceTransfer.caseParticipantRoleID
AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID
|