Operation Details |
Description: | Reads the goal details for a baseline gantt. |
Sterotype: | ns |
SQL |
SELECT PlannedGoal.plannedGoalID, Goal.name, PlannedGoal.expectedStartDate, PlannedGoal.expectedEndDate, PlannedGoal.actualStartDate, PlannedGoal.actualEndDate INTO :plannedGoalID, :name, :expectedStartDate, :expectedEndDate, :actualStartDate, :actualEndDate FROM PlannedGoal, Goal WHERE PlannedGoal.caseID = :caseID AND Goal.goalID = PlannedGoal.goalID |