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_SF52_DO_UPDATE dependencies on PER_POSITION_EXTRA_INFO

Line 64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;

60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
65: l_pos1_cre_ovn per_position_extra_info.object_version_number%type;
66: --
67: l_information1 varchar2(150);
68: l_information2 varchar2(150);

Line 65: l_pos1_cre_ovn per_position_extra_info.object_version_number%type;

61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
65: l_pos1_cre_ovn per_position_extra_info.object_version_number%type;
66: --
67: l_information1 varchar2(150);
68: l_information2 varchar2(150);
69: l_information3 varchar2(150);

Line 119: from per_position_extra_info

115:
116: Cursor c_pos_ei is
117: select position_extra_info_id,
118: object_version_number
119: from per_position_extra_info
120: where position_id = l_id
121: and information_type = p_l_information_type;
122:
123: begin

Line 1290: l_org_structure_id per_position_extra_info.poei_information5%type; -------bug#2623692

1286: l_posn_title_pm varchar2(50);
1287: l_WS_pm varchar2(50);
1288: l_DS_pm varchar2(50);
1289: l_personnel_office_id ghr_pa_requests.personnel_office_id%type; --\
1290: l_org_structure_id per_position_extra_info.poei_information5%type; -------bug#2623692
1291: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1292: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1293: Cursor get_to_posn_title_pm is
1294: select fpm.process_method_code

Line 1291: l_Organ_Component per_position_extra_info.poei_information5%type; --/

1287: l_WS_pm varchar2(50);
1288: l_DS_pm varchar2(50);
1289: l_personnel_office_id ghr_pa_requests.personnel_office_id%type; --\
1290: l_org_structure_id per_position_extra_info.poei_information5%type; -------bug#2623692
1291: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1292: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1293: Cursor get_to_posn_title_pm is
1294: select fpm.process_method_code
1295: from ghr_noa_families nof

Line 1321: from per_position_extra_info

1317:
1318: ------------------ cursor created to handle Null Org Struct id for MRE Correction
1319: Cursor c_pei_null_OPM(p_position_id number) is
1320: select poei_information5 l_org_structure_id
1321: from per_position_extra_info
1322: where information_type='GHR_US_POS_GRP1' and position_id=p_position_id;
1323:
1324: ----------------------------------- cursor to handle changes to LAC codes for Correction to Apptmt action 1274541
1325: Cursor c_Corr_LAC_Codes(p_pa_request_id number) is

Line 3474: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;

3470: --bug 4542437
3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3472: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3473: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3474: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3475: l_pos_ei_data per_position_extra_info%ROWTYPE;
3476: Begin
3477: --
3478: -- Remember IN OUT parameter IN values

Line 3475: l_pos_ei_data per_position_extra_info%ROWTYPE;

3471: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3472: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3473: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3474: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3475: l_pos_ei_data per_position_extra_info%ROWTYPE;
3476: Begin
3477: --
3478: -- Remember IN OUT parameter IN values
3479: --

Line 7918: l_pos_ei_data per_position_extra_info%ROWTYPE;

7914: l_step4value varchar2(80);
7915: l_step7value varchar2(80);
7916: l_step10value varchar2(80);
7917: l_dummy_date date;
7918: l_pos_ei_data per_position_extra_info%ROWTYPE;
7919:
7920: Begin
7921: hr_utility.set_location('entering ' || l_proc,5);
7922: If nvl(p_pa_request_rec.pay_Rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') then