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_GHRWS52L dependencies on PER_PEOPLE_EXTRA_INFO

Line 38: l_credit_mil_svc per_people_extra_info.pei_information5%type;

34: l_as_of_date date;
35: l_Benefit_Amount ghr_pa_request_extra_info.rei_information7%type;
36: l_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
37: l_citizenship ghr_pa_requests.CITIZENSHIP%type;
38: l_credit_mil_svc per_people_extra_info.pei_information5%type;
39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;

Line 39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;

35: l_Benefit_Amount ghr_pa_request_extra_info.rei_information7%type;
36: l_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
37: l_citizenship ghr_pa_requests.CITIZENSHIP%type;
38: l_credit_mil_svc per_people_extra_info.pei_information5%type;
39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;

Line 40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

36: l_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
37: l_citizenship ghr_pa_requests.CITIZENSHIP%type;
38: l_credit_mil_svc per_people_extra_info.pei_information5%type;
39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;

Line 50: l_fers_coverage per_people_extra_info.pei_information3%type;

46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
47: l_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
48: l_employee_National_ID per_people_f.national_identifier%type;
49: l_fegli_code ghr_pa_requests.FEGLI%type;
50: l_fers_coverage per_people_extra_info.pei_information3%type;
51: l_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
52: l_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
53: l_First_NOAC_Lookup_Code ghr_pa_requests.FIRST_NOA_CODE%type;
54: -- Bug#4486823 RRR Changes

Line 59: l_Handicap per_people_extra_info.pei_information11%type;

55: l_First_NOAC_Lookup_Desc ghr_pa_requests.FIRST_NOA_DESC%type;
56: l_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
57: l_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
58: l_health_plan varchar2(30);
59: l_Handicap per_people_extra_info.pei_information11%type;
60: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%type;
61: --l_locality_pay_area hr_location_extra_info.lei_information4%type;
62: l_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
63: l_Occupation_code ghr_pa_requests.to_occ_code%type;

Line 84: l_Race_National_Region per_people_extra_info.pei_information5%type;

80: l_Prior_Pay_Rate_Det_Code per_assignment_extra_info.aei_information6%type;
81: l_Prior_Step_Or_Rate per_assignment_extra_info.aei_information3%type;
82: l_prior_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
83: l_Production_Date date;
84: l_Race_National_Region per_people_extra_info.pei_information5%type;
85: l_rating_of_record_level ghr_pa_request_extra_info.rei_information5%type;
86: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%type;
87: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%type;
88: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117

Line 89: l_retain_grade per_people_extra_info.pei_information3%type;

85: l_rating_of_record_level ghr_pa_request_extra_info.rei_information5%type;
86: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%type;
87: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%type;
88: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117
89: l_retain_grade per_people_extra_info.pei_information3%type;
90: l_retain_pay_plan per_people_extra_info.pei_information5%type;
91: l_retain_step per_people_extra_info.pei_information4%type;
92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;

Line 90: l_retain_pay_plan per_people_extra_info.pei_information5%type;

86: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%type;
87: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%type;
88: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117
89: l_retain_grade per_people_extra_info.pei_information3%type;
90: l_retain_pay_plan per_people_extra_info.pei_information5%type;
91: l_retain_step per_people_extra_info.pei_information4%type;
92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)

Line 91: l_retain_step per_people_extra_info.pei_information4%type;

87: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%type;
88: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117
89: l_retain_grade per_people_extra_info.pei_information3%type;
90: l_retain_pay_plan per_people_extra_info.pei_information5%type;
91: l_retain_step per_people_extra_info.pei_information4%type;
92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)
95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;

Line 92: l_temp_step per_people_extra_info.pei_information9%type;

88: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117
89: l_retain_grade per_people_extra_info.pei_information3%type;
90: l_retain_pay_plan per_people_extra_info.pei_information5%type;
91: l_retain_step per_people_extra_info.pei_information4%type;
92: l_temp_step per_people_extra_info.pei_information9%type;
93: l_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
94: l_Retention_Allowance varchar2(30); -- ghr_pa_requests.TO_RETENTION_ALLOWANCE%type; --number(15,2)
95: l_Second_NOAC_Lookup_code ghr_pa_requests.SECOND_NOA_CODE%type;
96: l_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;

Line 285: FROM per_people_extra_info pei

281: and nvl(rei_information30,hr_api.g_varchar2) <> 'Original RPA';
282:
283: Cursor c_rg_pei is
284: SELECT count(person_extra_info_id) pei_count
285: FROM per_people_extra_info pei
286: WHERE pei.person_id = p_pa_request_rec.person_id
287: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
288: AND l_effective_date
289: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,l_effective_date)