APPS.PER_REFRESH_POSITION dependencies on HR_ALL_POSITIONS_F

Line 306: from hr_all_positions_f

302: , proposed_date_for_layoff
303: , pay_basis_id
304: , supervisor_id
305: , copied_to_old_table_flag
306: from hr_all_positions_f
307: where (copied_to_old_table_flag <> 'Y'
308: or copied_to_old_table_flag is null )
309: --and effective_start_date <= p_refresh_date
310: and position_id = p_position_id

Line 453: from hr_all_positions_f

449: , proposed_date_for_layoff
450: , pay_basis_id
451: , supervisor_id
452: , copied_to_old_table_flag
453: from hr_all_positions_f
454: where (copied_to_old_table_flag <> 'Y'
455: or copied_to_old_table_flag is null )
456: --and effective_start_date <= p_refresh_date
457: order by position_id, effective_start_date desc;

Line 740: and position_id not in ( select position_id from hr_all_positions_f where position_id = p_position_id) ;

736: cursor c_chk_pos is
737: select object_version_number
738: from per_all_positions p
739: where position_id = p_position_id
740: and position_id not in ( select position_id from hr_all_positions_f where position_id = p_position_id) ;
741: begin
742: hr_utility.set_location('Entering:'||g_package||'refresh_position_purge', 600);
743: for i in c_chk_pos loop
744: per_pos_del.del

Line 787: -- purge position if purged from hr_all_positions_f

783: , errbuf => l_errbuf
784: , retcode => l_retcode );
785: end if;
786: --
787: -- purge position if purged from hr_all_positions_f
788: --
789: refresh_position_purge(p_position_id => p_position_id);
790: --
791: -- following update is put in place for Non HR Products who refers per_all_positions