DBA Data[Home] [Help]

APPS.GHR_GHRWS52L dependencies on PER_PEOPLE_EXTRA_INFO

Line 15: g_credit_mil_svc per_people_extra_info.pei_information5%type;

11: g_as_of_date date;
12: g_Benefit_Amount varchar2(30);
13: g_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
14: g_citizenship ghr_pa_requests.CITIZENSHIP%type;
15: g_credit_mil_svc per_people_extra_info.pei_information5%type;
16: g_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
18: g_Duty_Station_ID hr_location_extra_info.lei_information3%type;
19: g_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;

Line 16: g_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;

12: g_Benefit_Amount varchar2(30);
13: g_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
14: g_citizenship ghr_pa_requests.CITIZENSHIP%type;
15: g_credit_mil_svc per_people_extra_info.pei_information5%type;
16: g_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
18: g_Duty_Station_ID hr_location_extra_info.lei_information3%type;
19: g_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
20: g_education_level ghr_pa_requests.EDUCATION_LEVEL%type;

Line 17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

13: g_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
14: g_citizenship ghr_pa_requests.CITIZENSHIP%type;
15: g_credit_mil_svc per_people_extra_info.pei_information5%type;
16: g_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
18: g_Duty_Station_ID hr_location_extra_info.lei_information3%type;
19: g_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
20: g_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
21: g_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;

Line 27: g_fers_coverage per_people_extra_info.pei_information3%type;

23: g_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
25: g_employee_National_ID varchar2(30);
26: g_fegli_code ghr_pa_requests.FEGLI%type;
27: g_fers_coverage per_people_extra_info.pei_information3%type;
28: g_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
29: g_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
30: g_First_NOAC_Lookup_Code varchar2(30);
31: -- Bug#4486823 RRR Changes

Line 36: g_Handicap per_people_extra_info.pei_information11%type;

32: g_First_NOAC_Lookup_desc ghr_pa_requests.first_noa_desc%TYPE;
33: g_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
34: g_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
35: g_health_plan varchar2(30);
36: g_Handicap per_people_extra_info.pei_information11%type;
37: g_Indiv_Award varchar2(30);
38: g_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
39: g_Occupation_code ghr_pa_requests.to_occ_code%type;
40: g_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;

Line 57: g_Race_National_Region per_people_extra_info.pei_information5%type;

53: g_Prior_Pay_Rate_Det_Code per_assignment_extra_info.aei_information6%type;
54: g_Prior_Step_Or_Rate per_assignment_extra_info.aei_information3%type;
55: g_prior_work_schedule_code varchar2(30);
56: g_Production_Date date;
57: g_Race_National_Region per_people_extra_info.pei_information5%type;
58: g_rating_of_record_level varchar2(30);
59: g_rating_of_record_pattern varchar2(30);
60: g_rating_of_record_period varchar2(30);
61: g_retain_grade per_people_extra_info.pei_information3%type;

Line 61: g_retain_grade per_people_extra_info.pei_information3%type;

57: g_Race_National_Region per_people_extra_info.pei_information5%type;
58: g_rating_of_record_level varchar2(30);
59: g_rating_of_record_pattern varchar2(30);
60: g_rating_of_record_period varchar2(30);
61: g_retain_grade per_people_extra_info.pei_information3%type;
62: g_retain_pay_plan per_people_extra_info.pei_information5%type;
63: g_retain_step per_people_extra_info.pei_information4%type;
64: g_temp_step per_people_extra_info.pei_information9%type;
65: g_fw_annualize varchar2(1);

Line 62: g_retain_pay_plan per_people_extra_info.pei_information5%type;

58: g_rating_of_record_level varchar2(30);
59: g_rating_of_record_pattern varchar2(30);
60: g_rating_of_record_period varchar2(30);
61: g_retain_grade per_people_extra_info.pei_information3%type;
62: g_retain_pay_plan per_people_extra_info.pei_information5%type;
63: g_retain_step per_people_extra_info.pei_information4%type;
64: g_temp_step per_people_extra_info.pei_information9%type;
65: g_fw_annualize varchar2(1);
66: g_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;

Line 63: g_retain_step per_people_extra_info.pei_information4%type;

59: g_rating_of_record_pattern varchar2(30);
60: g_rating_of_record_period varchar2(30);
61: g_retain_grade per_people_extra_info.pei_information3%type;
62: g_retain_pay_plan per_people_extra_info.pei_information5%type;
63: g_retain_step per_people_extra_info.pei_information4%type;
64: g_temp_step per_people_extra_info.pei_information9%type;
65: g_fw_annualize varchar2(1);
66: g_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
67: g_Retention_Allowance varchar2(30);

Line 64: g_temp_step per_people_extra_info.pei_information9%type;

60: g_rating_of_record_period varchar2(30);
61: g_retain_grade per_people_extra_info.pei_information3%type;
62: g_retain_pay_plan per_people_extra_info.pei_information5%type;
63: g_retain_step per_people_extra_info.pei_information4%type;
64: g_temp_step per_people_extra_info.pei_information9%type;
65: g_fw_annualize varchar2(1);
66: g_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
67: g_Retention_Allowance varchar2(30);
68: g_Second_NOAC_Lookup_code varchar2(30);