Operation Details
Description: Returns plannedGroupID, parentGroupID, planned group name, start date, and end date of all existing groups of the specified planned group.
Sterotype: nsmulti
SQL
SELECT
  PlannedGroup.plannedGroupID,
  PlannedGroup.parentGroupID,
  PlannedGroup.name,
  PlannedGroup.expectedStartDate,
  PlannedGroup.expectedEndDate,
  PlannedGroup.actualStartDate,
  PlannedGroup.actualEndDate
INTO
  :plannedGroupID,
  :parentGroupID,
  :plannedGroupName,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate 
FROM
  PlannedGroup 
WHERE PlannedGroup.parentGroupID = :plannedGroupID