Database SQL Operation: SlotAllocation.searchAppealsByEffectiveDateLocationAndScheduleType
Description: | Returns a list of slot allocations with the number with work units greater than zero for a particular location for a particual after an effective date. |
Sterotype: | nsmulti |
SELECT
SlotAllocation.slotAllocationID,
SlotAllocation.slotID,
SlotAllocation.slotAllocationDate,
SlotAllocation.numberWorkUnits,
SlotAllocation.versionNo
INTO
:slotAllocationID,
:slotID,
:slotAllocationDate,
:numberWorkUnits,
:versionNo
FROM
SlotAllocation,
DailySchedule,
Slot
WHERE DailySchedule.locationID = :locationID
AND DailySchedule.effectiveDate >= :effectiveDate
AND Slot.scheduleID = DailySchedule.scheduleID
AND SlotAllocation.slotID = Slot.slotID
AND SlotAllocation.numberWorkUnits > 0
AND (DailySchedule.type is null OR Dailyschedule.type = :locationScheduleType)
|