Database SQL Operation: LegalCaseTypeLink.searchAssociatedIntegratedCase
Description: | Returns the list of Legal Case Type Association details for a Legal Action ID and Integrated Case Type. |
Sterotype: | nsmulti |
SELECT
LEGALCASETYPELINK.LEGALCASETYPELINKID,
ADMININTEGRATEDCASE.INTEGRATEDCASETYPE
INTO
:legalCaseTypeLinkID,
:intCaseType
FROM
ADMININTEGRATEDCASE,
LEGALCASETYPELINK
WHERE ADMININTEGRATEDCASE.ADMININTEGRATEDCASEID =LEGALCASETYPELINK.RELATEDID
AND LEGALCASETYPELINK.ASSOCIATEDCASETYPE = :associatedCaseType
AND LEGALCASETYPELINK.CONFIGLEGALACTIONID = :configLegalActionID
|