Operation Details
Description: To retrieve the records using the case type and the relatedID.
Sterotype: nsmulti
SQL 
SELECT
  CASEMULTILEGALSTATUSCONFIG.MULTIPLECASELINKID,
  PRODUCT.NAME,
  PRODUCT.STARTDATE,
  PRODUCT.ENDDATE,
  CASEMULTILEGALSTATUSCONFIG.MULTIPLELEGALSTATUSIND
INTO
  :legalStatusCaseTypeLinkID,
  :caseTypeCode,
  :startDate,
  :endDate,
  :multipleLegalStatusInd 
FROM
  PRODUCT,
  CASEMULTILEGALSTATUSCONFIG 
WHERE PRODUCT.PRODUCTID = CASEMULTILEGALSTATUSCONFIG.RELATEDID 
  AND CASEMULTILEGALSTATUSCONFIG.ASSOCIATEDCASETYPECODE = :associatedCaseTypeCode