Database SQL Operation: LegalCaseTypeLink.searchAssociatedProductCase
Description: | Returns the list of Legal Case Type Association details for a Legal Action ID and Product Case Type. |
Sterotype: | nsmulti |
SELECT
LEGALCASETYPELINK.LEGALCASETYPELINKID,
PRODUCT.NAME,
PRODUCT.STARTDATE,
PRODUCT.ENDDATE
INTO
:legalCaseTypeLinkID,
:caseType,
:startDate,
:endDate
FROM
PRODUCT,
LEGALCASETYPELINK
WHERE PRODUCT.PRODUCTID =LEGALCASETYPELINK.RELATEDID
AND LEGALCASETYPELINK.ASSOCIATEDCASETYPE = :associatedCaseType
AND LEGALCASETYPELINK.CONFIGLEGALACTIONID = :configLegalActionID
|