DBA Data[Home] [Help]

APPS.HR_PAP_BUS dependencies on HR_PATTERN_BITS

Line 44: from hr_pattern_bits BIT,

40: -- not a qualifying or non-qualifying day.
41: --
42: union all
43: select 1
44: from hr_pattern_bits BIT,
45: hr_pattern_constructions CON
46: where con.pattern_bit_id = bit.pattern_bit_id
47: and con.pattern_id = p_pattern_id
48: and (bit.time_unit_multiplier <> ceil (bit.time_unit_multiplier)

Line 59: from hr_pattern_bits BIT,

55: -- not a qualifying or non-qualifying day.
56: --
57: union all
58: select 1
59: from hr_pattern_bits BIT,
60: hr_pattern_constructions CON,
61: hr_pattern_constructions CON2
62: where bit.pattern_bit_id = con2.pattern_bit_id
63: and con.pattern_id = p_pattern_id