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 476: FROM hr_all_positions_f

472: IF (UPPER(SUBSTR(p_sf52_data.request_number,1,3)) = 'MTO') THEN
473: -- End 2835138
474: SELECT name, object_version_number
475: INTO l_pos_name, l_object_version_number
476: FROM hr_all_positions_f
477: WHERE position_id = p_sf52_data.from_position_id
478: AND (p_sf52_data.effective_date - 1) BETWEEN effective_start_date
479: AND effective_end_date;
480: hr_position_api.delete_position

Line 1475: FROM hr_all_positions_f

1471:
1472:
1473: SELECT name, object_version_number
1474: INTO l_pos_name, l_object_version_number
1475: FROM hr_all_positions_f
1476: WHERE position_id = l_par.from_position_id
1477: AND (l_par.effective_date - 1) BETWEEN effective_start_date
1478: AND effective_end_date;
1479: hr_position_api.delete_position

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

4447: -- be a non datetracked table. Bug# 1252481
4448: PROCEDURE delete_posn_row( p_position_id in varchar2,
4449: p_dt_mode in varchar2,
4450: p_date_effective in date) IS
4451: l_proc varchar2(72) := 'delete_hr_all_positions_f_row';
4452: l_ovn number;
4453: l_pos_ovn number;
4454: l_effective_start_date date;
4455: l_effective_end_date date;

Line 4459: FROM HR_ALL_POSITIONS_F

4455: l_effective_end_date date;
4456: cursor c_get_ovn (cp_position_id in number,
4457: cp_date_effective in date) is
4458: SELECT object_version_number
4459: FROM HR_ALL_POSITIONS_F
4460: WHERE position_id = cp_position_id
4461: AND cp_date_effective between effective_start_date and effective_end_date;
4462:
4463: --Bug #12412678

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

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:
4472: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4473: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4474: SELECT psf.position_definition_id

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

4468: where position_id = p_position_id;
4469:
4470: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl
4471:
4472: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4473: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4474: SELECT psf.position_definition_id
4475: FROM hr_all_positions_f psf
4476: WHERE position_id = c_position_id

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

4469:
4470: -- Bug 3786467 Procedure to update position name in hr_all_positions_f_tl
4471:
4472: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4473: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4474: SELECT psf.position_definition_id
4475: FROM hr_all_positions_f psf
4476: WHERE position_id = c_position_id
4477: AND effective_end_date = hr_api.g_eot

Line 4475: FROM hr_all_positions_f psf

4471:
4472: PROCEDURE ghr_regenerate_position_name(p_position_id IN hr_all_positions_f.position_id%type) IS
4473: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4474: SELECT psf.position_definition_id
4475: FROM hr_all_positions_f psf
4476: WHERE position_id = c_position_id
4477: AND effective_end_date = hr_api.g_eot
4478: FOR UPDATE;
4479: --

Line 4525: update hr_all_positions_f

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;
4529:

Line 7109: from HR_ALL_POSITIONS_F apf

7105: IS
7106:
7107: CURSOR c_posn IS
7108: select apf.effective_start_date, apf.effective_end_date
7109: from HR_ALL_POSITIONS_F apf
7110: where apf.position_id = p_position_id
7111: and apf.availability_status_id <> 1
7112: and p_effective_date between apf.effective_start_date and apf.effective_end_date;
7113:

Line 7116: from HR_ALL_POSITIONS_F apf

7112: and p_effective_date between apf.effective_start_date and apf.effective_end_date;
7113:
7114: CURSOR c_prior_posn IS
7115: select apf.object_version_number
7116: from HR_ALL_POSITIONS_F apf
7117: where apf.position_id = p_position_id
7118: and p_posn_eff_start_date-1 between apf.effective_start_date and apf.effective_end_date;
7119:
7120: BEGIN

Line 7329: FROM hr_all_positions_f pos -- Venkat -- Position DT

7325: SELECT pos.job_id
7326: ,pos.business_group_id
7327: ,pos.organization_id
7328: ,pos.location_id
7329: FROM hr_all_positions_f pos -- Venkat -- Position DT
7330: WHERE pos.position_id = p_position_id
7331: and p_effective_date between pos.effective_start_date
7332: and pos.effective_end_date ;
7333: --BUG 6976052