Operation Details |
Description: | @deprecated since Curam v6, replaced with {@link readGoalGroupDetailsForTrackingGanttByCaseID}. The return parameter struct TrackingGanttGoalDetails has all the details of curam.serviceplans.sl.struct.TrackingGanttGoalDetails along with 'caseID'. |
Sterotype: | ns |
SQL |
SELECT PlannedGoal.plannedGoalID, Goal.name, PlannedGoal.expectedStartDate, PlannedGoal.expectedEndDate, PlannedGoal.actualStartDate, PlannedGoal.actualEndDate INTO :plannedGoalID, :goalName, :expectedStartDate, :expectedEndDate, :actualStartDate, :actualEndDate FROM PlannedGoal, Goal WHERE PlannedGoal.caseID = :caseID AND Goal.goalID = PlannedGoal.goalID |