SELECT
MilestoneDelivery.milestoneDeliveryID,
MilestoneConfiguration.name,
MilestoneConfiguration.type,
MilestoneDelivery.expectedStartDate,
MilestoneDelivery.expectedEndDate,
MilestoneDelivery.actualStartDate,
MilestoneDelivery.actualEndDate,
MilestoneDelivery.status
INTO
:milestoneDeliveryID,
:name,
:type,
:expectedStartDate,
:expectedEndDate,
:actualStartDate,
:actualEndDate,
:status
FROM
MilestoneConfiguration,
MilestoneDelivery,
SPMilestoneDeliveryLink
WHERE MilestoneDelivery.caseID = :caseID
AND SPMilestoneDeliveryLink.milestoneDeliveryID = MilestoneDelivery.milestoneDeliveryID
AND MilestoneDelivery.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
AND SPMilestoneDeliveryLink.plannedGroupID = :plannedGroupID
|