DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on PER_PEOPLE_EXTRA_INFO

Line 7: l_people_hist_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;

3: --
4: g_package varchar2(33) := 'GHR_SF113_A.';
5: --
6: l_asgn_hist_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
7: l_people_hist_data PER_PEOPLE_EXTRA_INFO%ROWTYPE;
8: l_pos_hist_data PER_POSITION_EXTRA_INFO%ROWTYPE;
9: l_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
10: l_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
11: l_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;

Line 22: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;

18: l_date_effective HR_ALL_POSITIONS_F.DATE_END%TYPE;
19: l_work_schedule PER_POSITION_EXTRA_INFO. POEI_INFORMATION10%TYPE;
20: l_position_code PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%TYPE;
21: l_pay_basis PER_POSITION_EXTRA_INFO.POEI_INFORMATION6%TYPE;
22: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
23: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
24: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;
25: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;
26: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;

Line 23: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;

19: l_work_schedule PER_POSITION_EXTRA_INFO. POEI_INFORMATION10%TYPE;
20: l_position_code PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%TYPE;
21: l_pay_basis PER_POSITION_EXTRA_INFO.POEI_INFORMATION6%TYPE;
22: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
23: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
24: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;
25: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;
26: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;
27: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;

Line 24: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;

20: l_position_code PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%TYPE;
21: l_pay_basis PER_POSITION_EXTRA_INFO.POEI_INFORMATION6%TYPE;
22: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
23: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
24: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;
25: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;
26: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;
27: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;
28: l_duty_station_code GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;

Line 25: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;

21: l_pay_basis PER_POSITION_EXTRA_INFO.POEI_INFORMATION6%TYPE;
22: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
23: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
24: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;
25: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;
26: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;
27: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;
28: l_duty_station_code GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
29: l_duty_station GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;

Line 26: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;

22: l_citizenship PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
23: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
24: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;
25: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;
26: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;
27: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;
28: l_duty_station_code GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
29: l_duty_station GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
30: l_msa_code GHR_DUTY_STATIONS_F.MSA_CODE%TYPE;