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 |