Operation Details
Description: This method is used to get the contract text for a planned item. It reads it by language code and planned item ID.
Sterotype: ns
SQL 
SELECT
  PlannedItem.plannedItemID,
  SE.contractText
INTO
  :plannedItemID,
  :planItemContractText 
FROM
  (PlanItemContractText INNER JOIN
  
  ( 
  SELECT
    ContractText,
    contractTextID 
  FROM
    ContractText
  WHERE ContractText.languageCode = :languageCode 
  ) SE 
  ON PlanItemContractText.contractTextID = SE.contractTextID ) 
  
  RIGHT JOIN
    PlannedItem 
    ON PlanItemContractText.planItemID = PlannedItem.planItemID 
WHERE PlannedItem.plannedItemID = :plannedItemID