DBA Data[Home] [Help]

APPS.HR_PAP_BUS dependencies on HR_PATTERN_CONSTRUCTIONS

Line 45: hr_pattern_constructions CON

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)
49: or bit.base_time_unit <> 'DAYS'

Line 60: hr_pattern_constructions CON,

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
64: and con.component_pattern_id = con2.pattern_id

Line 61: hr_pattern_constructions CON2

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
64: and con.component_pattern_id = con2.pattern_id
65: and (bit.time_unit_multiplier <> ceil (bit.time_unit_multiplier)