DBA Data[Home] [Help]

APPS.HR_CALENDAR_PKG dependencies on HR_PATTERN_BITS

Line 120: hr_pattern_bits BIT1

116: con1.sequence_no,
117: 0,
118: con1.availability
119: from hr_pattern_constructions CON1,
120: hr_pattern_bits BIT1
121: where bit1.pattern_bit_id = con1.pattern_bit_id
122: and con1.pattern_id = p_pattern_id
123: union all
124: select bit2.time_unit_multiplier,

Line 129: from hr_pattern_bits BIT2,

125: bit2.base_time_unit,
126: con2.sequence_no,
127: con3.sequence_no,
128: con3.availability
129: from hr_pattern_bits BIT2,
130: hr_pattern_constructions CON2,
131: hr_pattern_constructions CON3
132: where bit2.pattern_bit_id = con3.pattern_bit_id
133: and con2.component_pattern_id = con3.pattern_id