Operation Details
Description: Searches for good causes related to this planItem.
Sterotype: nsmulti
SQL
SELECT
  GoodCause.goodCauseID,
  GoodCause.name,
  GoodCause.dateCreated
INTO
  :goodCauseID,
  :name,
  :dateCreated 
FROM
  PlanItemGoodCauseLink,
  GoodCause 
WHERE PlanItemGoodCauseLink.planItemID = :planItemID 
  AND GoodCause.goodCauseID = PlanItemGoodCauseLink.goodCauseID