Database SQL Operation: HearingServiceSupplier.searchUserDetailsWithVersionNumbersByHearingID
Description: | Returns the details, including versionNo, for all user type service suppliers for the specified hearingID. |
Sterotype: | nsmulti |
SELECT
recordStatus,
participatedCode,
CaseUserRole.orgObjectLinkID,
typeCode,
HearingServiceSupplier.versionNo
INTO
:recordStatus,
:participatedCode,
:orgObjectLinkID,
:typeCode,
:versionNoOpt
FROM
HearingServiceSupplier,
CaseUserRole
WHERE hearingID = :hearingID
AND supplierType = :supplierType
AND supplierLinkID = caseUserRoleID
|