30: --
31: -- Find pattern which is not required to start at midnight
32: --
33: select 1 34: from hr_patterns 35: where pattern_id = p_pattern_id
36: and pattern_start_time <> '00:00'
37: --
38: -- Find, for construction rows based directly on pattern bits, any