| Operation Details |  |
| Description: | Searches for contract texts associated with a sub goal. |
| Sterotype: | nsmulti |
| SQL | |
SELECT ContractText.contractTextID, ContractText.contractText, ContractText.languageCode INTO :contractTextID, :contractText, :languageCode FROM SubGoalContractText, ContractText WHERE SubGoalContractText.subGoalID = :subGoalID AND ContractText.contractTextID = SubGoalContractText.contractTextID |