Operation Details
Description: Reads concern role ID of the client for whom the planned item has been created.
Sterotype: ns
SQL 
SELECT
  CaseHeader.concernRoleID
INTO
  :concernRoleID 
FROM
  PlannedItem,
  PlannedSubGoal,
  PlannedGoal,
  CaseHeader 
WHERE PlannedItem.plannedItemID = :plannedItemID 
  AND PlannedSubGoal.plannedSubGoalID = PlannedItem.plannedSubGoalID 
  AND PlannedGoal.plannedGoalID = PlannedSubGoal.plannedGoalID 
  AND CaseHeader.caseID = PlannedGoal.caseID