SELECT   count(HolidayName) into :numberOfRecords
 FROM   LocationHoliday, LocationHolidayLink 
 WHERE
   LocationHolidayLink.locationHolidayID = LocationHoliday.locationHolidayID
   AND
    LocationHolidayLink.locationID = :locationID
   AND     LocationHoliday.holidayDate = :holidayDate
   AND    LocationHoliday.statusCode = :status