Operation Details |
Description: | Reads goal name and goal id for the service plan delivery. |
Sterotype: | ns |
SQL |
SELECT Goal.name, Goal.goalID INTO :name, :goalID FROM PlannedGoal, Goal WHERE PlannedGoal.caseID = :caseID AND Goal.goalID = PlannedGoal.goalID |