| Operation Details |  |
| Description: | Checks if the good cause is assigned to any planItem. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :recordCount FROM PlanItemGoodCauseLink, PlanItem WHERE PlanItemGoodCauseLink.goodCauseID = :goodCauseID AND PlanItemGoodCauseLink.planItemID = PlanItem.planItemID AND PlanItem.recordStatus = :recordStatus |