| Operation Details |  |
| Description: | Returns Legal Category ID for Legal Action Name |
| Sterotype: | ns |
| SQL | |
SELECT ADMINLEGALACTIONCATEGORY.LEGALACTIONCATEGORYID INTO :legalActionCategoryID FROM ADMINLEGALACTIONCATEGORY WHERE ADMINLEGALACTIONCATEGORY.LEGALCATEGORYNAMECODE = :legalCategoryNameCode AND ADMINLEGALACTIONCATEGORY.ENDDATE IS NULL |