APPS.HR_PAC_BUS dependencies on HR_PATTERN_BITS

Line 36: from hr_pattern_bits

32: --
33: cursor csr_pattern_bit is
34: --
35: select 1
36: from hr_pattern_bits
37: where pattern_bit_id = p_pattern_bit_id
38: and (time_unit_multiplier <> ceil (time_unit_multiplier)
39: or base_time_unit <> 'DAYS'
40: or p_availability is null

Line 44: from hr_pattern_bits BIT,

40: or p_availability is null
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)