Database SQL Operation: LegalStatusCaseTypeLink.searchSelectedLegalStatuses
Description: | To retrieve the records using the case type and the relatedID. |
Sterotype: | nsmulti |
SELECT
ADMINLEGALSTATUS.LEGALSTATUSID,
ADMINLEGALSTATUS.LEGALSTATUSTYPECODE,
LEGALSTATUSCASETYPELINK.LEGALSTATUSCASETYPELINKID
INTO
:legalStatusID,
:legalStatusTypeCode,
:legalStatusCaseTypeLinkID
FROM
ADMINLEGALSTATUS,
LEGALSTATUSCASETYPELINK,
CASEMULTILEGALSTATUSCONFIG
WHERE ADMINLEGALSTATUS.LEGALSTATUSID = LEGALSTATUSCASETYPELINK.CONFIGLEGALSTATUSID
AND LEGALSTATUSCASETYPELINK.MULTIPLECASELINKID =CASEMULTILEGALSTATUSCONFIG.MULTIPLECASELINKID
AND CASEMULTILEGALSTATUSCONFIG.ASSOCIATEDCASETYPECODE = :associatedCaseTypeCode
AND CASEMULTILEGALSTATUSCONFIG.RELATEDID = :relatedID
|