Operation Details
Description: @deprecated by readIDAndGoalContractTextByCaseID1. @deprecated-since V6.0 SP2. Reads the active planned goal id and goal contract text for a service plan id.
Sterotype: ns
SQL 
SELECT
  PlannedGoal.plannedGoalID,
  SE.contractText
INTO
  :plannedGoalID,
  :goalContractText 
FROM
  (GoalContractText INNER JOIN
  
  
  ( 
  SELECT
    ContractText,
    contractTextID 
  FROM
    ContractText,
    ConcernRole 
  WHERE ConcernRole.preferredLanguage = ContractText.languageCode 
    AND ConcernRole.concernRoleID = :concernRoleID 
  ) SE 
  ON GoalContractText.contractTextID = SE.contractTextID ) 
  
  RIGHT 
  
  JOIN
  
  PlannedGoal 
  ON GoalContractText.goalID = PlannedGoal.goalID 
WHERE PlannedGoal.caseID = :caseID