DBA Data[Home] [Help]

APPS.HR_CAL_BUS dependencies on HR_PATTERN_BITS

Line 151: hr_pattern_bits BIT1

147: bit1.base_time_unit,
148: con1.sequence_no,
149: 0
150: from hr_pattern_constructions CON1,
151: hr_pattern_bits BIT1
152: where bit1.pattern_bit_id = con1.pattern_bit_id
153: and con1.pattern_id = p_pattern_id
154: union all
155: select bit2.time_unit_multiplier,

Line 159: from hr_pattern_bits BIT2,

155: select bit2.time_unit_multiplier,
156: bit2.base_time_unit,
157: con2.sequence_no,
158: con3.sequence_no
159: from hr_pattern_bits BIT2,
160: hr_pattern_constructions CON2,
161: hr_pattern_constructions CON3
162: where bit2.pattern_bit_id = con3.pattern_bit_id
163: and con2.component_pattern_id = con3.pattern_id