APPS.GHR_DS_JAN99_PKG dependencies on HR_ALL_POSITIONS_F

Line 173: from hr_all_positions_f pos1

169: select pos1.position_id position_id,
170: pos1.name name,
171: pos1.effective_start_date effective_start_date,
172: pos1.object_version_number object_version_number
173: from hr_all_positions_f pos1
174: where l_effective_date between pos1.effective_start_date
175: and pos1.effective_end_date
176: and pos1.location_id = p_old_location_id
177: union

Line 182: from hr_all_positions_f pos2

178: select pos2.position_id position_id,
179: pos2.name name,
180: pos2.effective_start_date effective_start_date,
181: pos2.object_version_number object_version_number
182: from hr_all_positions_f pos2
183: where l_effective_date <= pos2.effective_start_date
184: and pos2.location_id = p_old_location_id
185: order by 1,3;
186:

Line 190: from hr_all_positions_f pos

186:
187: cursor c_pos_update_mode_a is
188: select pos.effective_start_date ,
189: pos.effective_end_date
190: from hr_all_positions_f pos
191: where pos.position_id = l_position_id
192: and l_assign_effective_date
193: between pos.effective_start_date
194: and pos.effective_end_date;

Line 199: from hr_all_positions_f pos

195:
196: cursor c_pos_update_mode_a1 is
197: select pos.effective_start_date ,
198: pos.effective_end_date
199: from hr_all_positions_f pos
200: where pos.position_id = l_position_id
201: and l_assign_effective_date < pos.effective_start_date;
202:
203: cursor cur_organizations is