DBA Data[Home] [Help]

APPS.HR_PAE_BUS dependencies on HR_PATTERN_CONSTRUCTIONS

Line 155: from hr_pattern_constructions con1,

151: select bit1.time_unit_multiplier tum,
152: bit1.base_time_unit btu,
153: con1.sequence_no,
154: 0
155: from hr_pattern_constructions con1,
156: hr_pattern_bits bit1
157: where bit1.pattern_bit_id = con1.pattern_bit_id
158: and con1.pattern_id = p_pattern_id
159: union all

Line 165: hr_pattern_constructions con2,

161: bit2.base_time_unit btu,
162: con2.sequence_no,
163: con3.sequence_no
164: from hr_pattern_bits bit2,
165: hr_pattern_constructions con2,
166: hr_pattern_constructions con3
167: where bit2.pattern_bit_id = con3.pattern_bit_id
168: and con2.component_pattern_id = con3.pattern_id
169: and con2.pattern_id = p_pattern_id

Line 166: hr_pattern_constructions con3

162: con2.sequence_no,
163: con3.sequence_no
164: from hr_pattern_bits bit2,
165: hr_pattern_constructions con2,
166: hr_pattern_constructions con3
167: where bit2.pattern_bit_id = con3.pattern_bit_id
168: and con2.component_pattern_id = con3.pattern_id
169: and con2.pattern_id = p_pattern_id
170: order by 3,4;