SELECT
BaselineSubGoal.baselineSubGoalID,
BaselineSubGoal.plannedSubGoalID,
BaselineSubGoal.name,
BaselineSubGoal.typeCode,
BaselineSubGoal.expectedStartDate,
BaselineSubGoal.expectedEndDate,
BaselineSubGoal.actualStartDate,
BaselineSubGoal.actualEndDate,
BaselineSubGoal.plannedGroupID
INTO
:baselineSubGoalID,
:plannedSubGoalID,
:name,
:typeCode,
:expectedStartDate,
:expectedEndDate,
:actualStartDate,
:actualEndDate,
:plannedGroupID
FROM
BaselineSubGoal
WHERE BaselineSubGoal.baseLineID = :baseLineID
AND BaselineSubGoal.sensitivityCode <= :sensitivityCode
AND BaselineSubGoal.plannedGroupID = :plannedGroupID
|