SELECT
BaselinePlanItem.baselinePlanItemID,
BaselinePlanItem.plannedItemID,
BaselinePlanItem.name,
BaselinePlanItem.authorizedUnits,
BaselinePlanItem.typeCode,
BaselinePlanItem.expectedStartDate,
BaselinePlanItem.expectedEndDate,
BaselinePlanItem.actualStartDate,
BaselinePlanItem.actualEndDate
INTO
:baselinePlanItemID,
:plannedItemID,
:name,
:authorizedUnits,
:typeCode,
:expectedStartDate,
:expectedEndDate,
:actualStartDate,
:actualEndDate
FROM
BaselinePlanItem
WHERE BaselinePlanItem.baselineSubGoalID = :baselineSubGoalID
AND BaselinePlanItem.sensitivityCode <= :sensitivityCode
|