eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CORR_CANC_SF52 dependencies on PER_ALL_POSITIONS

Line 4467: from per_all_positions

4463: --Bug #12412678
4464: cursor c1 (p_position_id in number)
4465: is
4466: select object_version_number
4467: from per_all_positions
4468: where position_id = p_position_id;
4469:
4470: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl
4471:

Line 4524: --Bug # 12412678 synchronizing the position in per_all_positions

4520: -- Regenerate Position Bug 3786467.
4521: hr_utility.set_location('Entered ghr regenerate position',15);
4522: ghr_regenerate_position_name(p_position_id);
4523:
4524: --Bug # 12412678 synchronizing the position in per_all_positions
4525: update hr_all_positions_f
4526: set copied_to_old_table_flag = 'N'
4527: where position_id = p_position_id and
4528: effective_end_date > p_date_effective - 1;

Line 4557: --Bug # 12412678 synchronizing the position in per_all_positions

4553: -- Regenerate Position Bug 3786467
4554: hr_utility.set_location('Entered ghr regenerate position',15);
4555: ghr_regenerate_position_name(p_position_id);
4556:
4557: --Bug # 12412678 synchronizing the position in per_all_positions
4558: open c1(p_position_id);
4559: fetch c1 into l_pos_ovn;
4560: close c1;
4561:

Line 4564: -- delete row from per_all_positions

4560: close c1;
4561:
4562: per_pos_shd.lck(p_position_id => p_position_id
4563: ,p_object_version_number => l_pos_ovn);
4564: -- delete row from per_all_positions
4565:
4566: per_pos_del.del(p_position_id => p_position_id
4567: ,p_object_version_number => l_pos_ovn);
4568: