| Operation Details |  |
| Description: | Gets a list of the goals associated with a service plan. |
| Sterotype: | nsmulti |
| SQL | |
SELECT
goalID,
name,
dateCreated
INTO
:goalID,
:goalName,
:dateCreated
FROM
Goal
WHERE goalID IN
(
SELECT
goalID
FROM
ServicePlanGoalLink
WHERE servicePlanID = :servicePlanID
)
|