Operation Details |
Description: | Count planItems that the outcome is associated with. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :recordCount FROM PlanItemOutcomeLink, PlanItem WHERE PlanItemOutcomeLink.outcomeID = :outcomeID AND PlanItemOutcomeLink.planItemID = PlanItem.planItemID AND PlanItem.recordStatus = :recordStatus |