Operation Details
Description: @deprecated by searchContractTextByPlannedSubGoalAndParticipant. @deprecated-since V6.0 SP2. See release note CR00287219. This method is used to get the contract text for a planned item.
Sterotype: nsmulti
SQL 
SELECT
  PlannedItem.plannedItemID,
  SE.contractText
INTO
  :plannedItemID,
  :planItemContractText 
FROM
  (PlanItemContractText INNER JOIN
  
  
  ( 
  SELECT
    ContractText,
    contractTextID 
  FROM
    ContractText,
    ConcernRole 
  WHERE ConcernRole.preferredLanguage = ContractText.languageCode 
    AND ConcernRole.concernRoleID = :concernRoleID 
  ) SE 
  ON PlanItemContractText.contractTextID = SE.contractTextID ) 
  
  RIGHT 
  
  JOIN
  
  PlannedItem 
  ON PlanItemContractText.planItemID = PlannedItem.planItemID 
WHERE PlannedItem.plannedSubGoalID = :plannedSubGoalID