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