Operation Details
Description: Reads case status of the service plan delivery for which the planed sub goal has been created.
Sterotype: ns
SQL 
SELECT
  CaseHeader.statusCode
INTO
  :statusCode 
FROM
  PlannedSubGoal,
  PlannedGoal,
  CaseHeader 
WHERE PlannedSubGoal.plannedSubGoalID = :plannedSubGoalID 
  AND PlannedGoal.plannedGoalID = PlannedSubGoal.plannedGoalID 
  AND CaseHeader.caseID = PlannedGoal.caseID