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 122: from per_position_extra_info

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

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

1302: l_posn_title_pm varchar2(50);
1303: l_WS_pm varchar2(50);
1304: l_DS_pm varchar2(50);
1305: l_personnel_office_id ghr_pa_requests.personnel_office_id%type; --\
1306: l_org_structure_id per_position_extra_info.poei_information5%type; -------bug#2623692
1307: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1308: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1309: Cursor get_to_posn_title_pm is
1310: select fpm.process_method_code

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

1303: l_WS_pm varchar2(50);
1304: l_DS_pm varchar2(50);
1305: l_personnel_office_id ghr_pa_requests.personnel_office_id%type; --\
1306: l_org_structure_id per_position_extra_info.poei_information5%type; -------bug#2623692
1307: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1308: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1309: Cursor get_to_posn_title_pm is
1310: select fpm.process_method_code
1311: from ghr_noa_families nof

Line 1337: from per_position_extra_info

1333:
1334: ------------------ cursor created to handle Null Org Struct id for MRE Correction
1335: Cursor c_pei_null_OPM(p_position_id number) is
1336: select poei_information5 l_org_structure_id
1337: from per_position_extra_info
1338: where information_type='GHR_US_POS_GRP1' and position_id=p_position_id;
1339:
1340: ----------------------------------- cursor to handle changes to LAC codes for Correction to Apptmt action 1274541
1341: Cursor c_Corr_LAC_Codes(p_pa_request_id number) is

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

3687: --bug 4542437
3688: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3689: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3690: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3691: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3692: l_pos_ei_data per_position_extra_info%ROWTYPE;
3693:
3694: --Bug # 6127620
3695: --l_curr_sess_date fnd_sessions.effective_date%type;

Line 3692: l_pos_ei_data per_position_extra_info%ROWTYPE;

3688: l_position_id ghr_pa_requests.from_position_id%TYPE :=NULL;
3689: l_job_id per_all_assignments_f.job_id%TYPE :=NULL;
3690: l_org_id per_all_assignments_f.organization_id%TYPE :=NULL;
3691: l_grade_id per_position_extra_info.poei_information3%TYPE :=NULL;
3692: l_pos_ei_data per_position_extra_info%ROWTYPE;
3693:
3694: --Bug # 6127620
3695: --l_curr_sess_date fnd_sessions.effective_date%type;
3696: Begin

Line 8221: l_pos_ei_data per_position_extra_info%ROWTYPE;

8217: l_step4value varchar2(80);
8218: l_step7value varchar2(80);
8219: l_step10value varchar2(80);
8220: l_dummy_date date;
8221: l_pos_ei_data per_position_extra_info%ROWTYPE;
8222:
8223: Begin
8224: hr_utility.set_location('entering ' || l_proc,5);
8225: If nvl(p_pa_request_rec.pay_Rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') then