APPS.HR_CAL_BUS dependencies on HR_PATTERN_CONSTRUCTIONS

Line 79: from hr_pattern_constructions

75: --
76: -- Get the number of pattern construction rows for the pattern
77: --
78: select count (*)
79: from hr_pattern_constructions
80: where pattern_id = p_pattern_id;
81: --
82: l_construction_rows integer := null;
83: l_proc varchar2(72) := g_package||'chk_pattern_start_position';

Line 150: from hr_pattern_constructions CON1,

146: select bit1.time_unit_multiplier,
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

Line 160: hr_pattern_constructions CON2,

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

Line 161: hr_pattern_constructions CON3

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