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 HR_ALL_POSITIONS_F

Line 461: FROM hr_all_positions_f

457: IF (UPPER(SUBSTR(p_sf52_data.request_number,1,3)) = 'MTO') THEN
458: -- End 2835138
459: SELECT name, object_version_number
460: INTO l_pos_name, l_object_version_number
461: FROM hr_all_positions_f
462: WHERE position_id = p_sf52_data.from_position_id
463: AND (p_sf52_data.effective_date - 1) BETWEEN effective_start_date
464: AND effective_end_date;
465: hr_position_api.delete_position

Line 1341: FROM hr_all_positions_f

1337: -- null out end_date for position
1338:
1339: SELECT name, object_version_number
1340: INTO l_pos_name, l_object_version_number
1341: FROM hr_all_positions_f
1342: WHERE position_id = l_par.from_position_id
1343: AND (l_par.effective_date - 1) BETWEEN effective_start_date
1344: AND effective_end_date;
1345: hr_position_api.delete_position

Line 4143: l_proc varchar2(72) := 'delete_hr_all_positions_f_row';

4139: -- be a non datetracked table. Bug# 1252481
4140: PROCEDURE delete_posn_row( p_position_id in varchar2,
4141: p_dt_mode in varchar2,
4142: p_date_effective in date) IS
4143: l_proc varchar2(72) := 'delete_hr_all_positions_f_row';
4144: l_ovn number;
4145: l_effective_start_date date;
4146: l_effective_end_date date;
4147: cursor c_get_ovn (cp_position_id in number,

Line 4150: FROM HR_ALL_POSITIONS_F

4146: l_effective_end_date date;
4147: cursor c_get_ovn (cp_position_id in number,
4148: cp_date_effective in date) is
4149: SELECT object_version_number
4150: FROM HR_ALL_POSITIONS_F
4151: WHERE position_id = cp_position_id
4152: AND cp_date_effective between effective_start_date and effective_end_date;
4153:
4154: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl

Line 4154: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl

4150: FROM HR_ALL_POSITIONS_F
4151: WHERE position_id = cp_position_id
4152: AND cp_date_effective between effective_start_date and effective_end_date;
4153:
4154: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl
4155:
4156: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4157: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4158: SELECT psf.position_definition_id

Line 4156: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS

4152: AND cp_date_effective between effective_start_date and effective_end_date;
4153:
4154: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl
4155:
4156: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4157: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4158: SELECT psf.position_definition_id
4159: FROM hr_all_positions_f psf
4160: WHERE position_id = c_position_id

Line 4157: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is

4153:
4154: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl
4155:
4156: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4157: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4158: SELECT psf.position_definition_id
4159: FROM hr_all_positions_f psf
4160: WHERE position_id = c_position_id
4161: AND effective_end_date = hr_api.g_eot

Line 4159: FROM hr_all_positions_f psf

4155:
4156: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4157: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4158: SELECT psf.position_definition_id
4159: FROM hr_all_positions_f psf
4160: WHERE position_id = c_position_id
4161: AND effective_end_date = hr_api.g_eot
4162: FOR UPDATE;
4163: --

Line 6754: from HR_ALL_POSITIONS_F apf

6750: IS
6751:
6752: CURSOR c_posn IS
6753: select apf.effective_start_date, apf.effective_end_date
6754: from HR_ALL_POSITIONS_F apf
6755: where apf.position_id = p_position_id
6756: and apf.availability_status_id <> 1
6757: and p_effective_date between apf.effective_start_date and apf.effective_end_date;
6758:

Line 6761: from HR_ALL_POSITIONS_F apf

6757: and p_effective_date between apf.effective_start_date and apf.effective_end_date;
6758:
6759: CURSOR c_prior_posn IS
6760: select apf.object_version_number
6761: from HR_ALL_POSITIONS_F apf
6762: where apf.position_id = p_position_id
6763: and p_posn_eff_start_date-1 between apf.effective_start_date and apf.effective_end_date;
6764:
6765: BEGIN