Database SQL Operation: LegalCaseTypeLink.searchAssociatedScreeningCase
Description: | Returns the list of Legal Case Type Association details for a Legal Action ID and Screening Case Type. |
Sterotype: | nsmulti |
SELECT
LEGALCASETYPELINK.LEGALCASETYPELINKID,
SCREENINGCONFIGURATION.NAME
INTO
:legalCaseTypeLinkID,
:caseType
FROM
SCREENINGCONFIGURATION,
LEGALCASETYPELINK
WHERE SCREENINGCONFIGURATION.SCREENINGCONFIGID =LEGALCASETYPELINK.RELATEDID
AND LEGALCASETYPELINK.ASSOCIATEDCASETYPE = :associatedCaseType
AND LEGALCASETYPELINK.CONFIGLEGALACTIONID = :configLegalActionID
|