Operation Details
Description: Retrieves all of the holiday records for the specified location with the specified status code (or all if status code is unspecified).
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.locationHolidayID = lhl.locationHolidayID 
  AND 
  (
    
    (
      :statusCode IS NULL 
    ) 
    OR 
    (
      lh.statusCode = :statusCode 
    ) 
  )