Operation Details |
Description: | Returns the Legal Action Name based on the Legal Action Case ID |
Sterotype: | ns |
SQL |
SELECT ADMINLEGALACTION.LEGALACTIONNAMECODE INTO :legalActionNameCode FROM LEGALACTION, ADMINLEGALACTION, CASEHEADER WHERE LEGALACTION.CONFIGLEGALACTIONID =ADMINLEGALACTION.LEGALACTIONID AND CASEHEADER.CASEID =LEGALACTION.CASEID AND LEGALACTION.CASEID = :caseID |