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