Operation Details
Description: Retrieves the holidays with the specified record status for the specified location over the specified date range.
Sterotype: nsmulti
SQL 
SELECT
  lh.locationHolidayID,
  lhl.locationID,
  lh.holidayName,
  lh.holidayDate,
  lh.statusCode
INTO
  :locationHolidayID,
  :locationID,
  :holidayName,
  :holidayDate,
  :statusCode 
FROM
  LocationHoliday lh,
  LocationHolidayLink lhl 
WHERE lhl.locationID = :locationID 
  AND lh.statusCode = :statusCode 
  AND lh.holidayDate >= :startDate 
  AND lh.holidayDate <= :endDate 
AND lhl.locationHolidayID=lh.locationHolidayID