APPS.HR_PAC_BUS dependencies on HR_PATTERN_CONSTRUCTIONS

Line 45: hr_pattern_constructions CON

41: or p_availability not in ('QUALIFYING','NON QUALIFYING'))
42: union all
43: select 1
44: from hr_pattern_bits BIT,
45: hr_pattern_constructions CON
46: where bit.pattern_bit_id = con.pattern_bit_id
47: and con.pattern_id = p_component_pattern_id
48: and (bit.time_unit_multiplier <> ceil (bit.time_unit_multiplier)
49: or bit.base_time_unit <> 'DAYS'

Line 180: from hr_pattern_constructions

176: -- Check that the component pattern is not itself made up of further
177: -- component patterns.
178: --
179: select 1
180: from hr_pattern_constructions
181: where pattern_id = p_component_pattern_id
182: and component_pattern_id is not null;
183: --
184: begin