Operation Details
Description: Returns the list of Legal Case Type Association details for a Legal Action ID and Product Case Type.
Sterotype: nsmulti
SQL
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