Operation Details |
Description: | reads the min and max for all planned groups for a specified parent planned group. |
Sterotype: | ns |
SQL |
SELECT MIN(PlannedGroup.actualStartDate), MAX(PlannedGroup.actualEndDate), MIN(PlannedGroup.expectedStartDate), MAX(PlannedGroup.expectedEndDate) INTO :actualStartDate, :actualEndDate, :expectedStartDate, :expectedEndDate FROM PlannedGroup WHERE PlannedGroup.parentGroupID = :plannedGroupID |