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