Operation Details
Description: Returns the list of Legal Case Type Association details for a Legal Action ID and Investigation Case Type.
Sterotype: nsmulti
SQL 
SELECT
  LEGALCASETYPELINK.LEGALCASETYPELINKID,
  INVESTIGATIONCONFIG.TYPE,
  INVESTIGATIONCONFIG.STARTDATE,
  INVESTIGATIONCONFIG.ENDDATE
INTO
  :legalCaseTypeLinkID,
  :caseType,
  :startDate,
  :endDate 
FROM
  INVESTIGATIONCONFIG,
  LEGALCASETYPELINK 
WHERE INVESTIGATIONCONFIG.INVESTIGATIONCONFIGID =LEGALCASETYPELINK.RELATEDID 
  AND LEGALCASETYPELINK.ASSOCIATEDCASETYPE = :associatedCaseType 
  AND LEGALCASETYPELINK.CONFIGLEGALACTIONID = :configLegalActionID