Database SQL Operation: Appeal.searchOrganisationAppellantTabDetail
| Description: | @deprecated by searchOrganisationAppellantToolTipDetail. @deprecated-since Curam version 6.0 SP2.The new operation returns the details required to read for the details for a tool tip for the Appellant.
|
| Sterotype: | nsmulti |
SELECT
OrganisationUnit.name
INTO
:orgUnitName
FROM
Appeal,
Appellant,
OrganisationUnit
WHERE
Appellant.appealID = (
SELECT DISTINCT
Appellant.appealID
FROM
Appellant
WHERE
Appeal.caseID = :caseID AND
Appellant.appealID = Appeal.appealID) AND
Appellant.caseParticipantRoleID = OrganisationUnit.organisationUnitID AND
(
Appellant.toDate IS NULL OR
Appellant.toDate < :currentDate
)
|
