SELECT
BaselineSubGoal.baselineSubGoalID,
PlannedSubGoal.plannedSubGoalID,
SubGoal.name,
SubGoal.typeCode,
PlannedSubGoal.expectedStartDate,
PlannedSubGoal.expectedEndDate
INTO
:baselineSubGoalID,
:plannedSubGoalID,
:name,
:typeCode,
:expectedStartDate,
:expectedEndDate
FROM
BaselineSubGoal,
PlannedSubGoal,
SubGoal
WHERE BaselineSubGoal.baseLineID = :baseLineID
AND BaselineSubGoal.sensitivityCode <= :sensitivityCode
AND PlannedSubGoal.plannedSubGoalID = BaselineSubGoal.plannedSubGoalID
AND SubGoal.subGoalID = PlannedSubGoal.subGoalID
|