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