Operation Details
Description: Retrieves a list of absence records for the specified planned item.
Sterotype: nsmulti
SQL 
SELECT
  AbsencePeriod.absencePeriodID,
  AbsencePeriod.absenceDate,
  AbsencePeriod.absenceReason,
  AbsencePeriod.unitsUnattended,
  AbsencePeriod.creationDate,
  AbsencePeriod.createdBySystem,
  AbsencePeriod.periodStartDate,
  AbsencePeriod.periodEndDate,
  AbsencePeriod.recordStatus,
  AbsencePeriod.versionNo
INTO
  :absencePeriodID,
  :absenceDate,
  :absenceReason,
  :unitsUnattended,
  :creationDate,
  :createdBySystem,
  :periodStartDate,
  :periodEndDate,
  :recordStatus,
  :versionNo 
FROM
  PlannedItemAbsenceLink,
  AbsencePeriod 
WHERE PlannedItemAbsenceLink.plannedItemID = :plannedItemID 
  AND AbsencePeriod.absencePeriodID = PlannedItemAbsenceLink.absencePeriodID 
ORDER BY AbsencePeriod.periodStartDate