| Operation Details |  |
| Description: | <p> @Deprecated </p> <p> Reads plannedGoalID, name and service plan status. </p> |
| Sterotype: | ns |
| SQL | |
SELECT
PlannedGoal.plannedGoalID,
Goal.name,
CaseHeader.statusCode
INTO
:plannedGoalID,
:goalName,
:plannedGoalStatus
FROM
PlannedGoal,
Goal,
CaseHeader
WHERE
(
PlannedGoal.caseID = :caseID
)
AND
(
CaseHeader.caseID = PlannedGoal.caseID
)
AND
(
PlannedGoal.goalID = Goal.goalID
)
|