Operation Details
Description:  
Sterotype: ns
SQL 
SELECT 
AdminLegalActionCategory.legalCategoryNameCode, 
AdminLegalAction.legalActionNameCode,
LegalHearing.docketNumber, 
LegalHearing.hearingOutcomeCode,
LegalAction.startDate,
LegalAction.statusCode

INTO 
:hearingCategoryCode,
:hearingNameCode, 
:docketNumber, 
:hearingOutcomeCode,
:startDate,
:status

FROM 
LegalHearing, 
AdminLegalActionCategory, 
LegalAction,  
AdminLegalAction

WHERE
LegalHearing.caseID = :caseID AND 
LegalAction.caseID = LegalHearing.caseID AND 
AdminLegalActionCategory.legalActionCategoryID = LegalAction.configLegalActionCategoryID  AND 
AdminLegalAction.legalActionID = LegalAction.configLegalActionID