DBA Data[Home] [Help]

APPS.HR_CALENDAR_PKG dependencies on HR_PATTERN_CONSTRUCTIONS

Line 119: from hr_pattern_constructions CON1,

115: bit1.base_time_unit,
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

Line 130: hr_pattern_constructions CON2,

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
134: and con2.pattern_id = p_pattern_id

Line 131: hr_pattern_constructions CON3

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
134: and con2.pattern_id = p_pattern_id
135: order by 3,4;