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 GHR_PA_REQUEST_EXTRA_INFO

Line 36: l_Benefit_Amount ghr_pa_request_extra_info.rei_information7%type;

32: l_Agency_Code varchar2(30);
33: -- l_Agency varchar2(30);
34: l_agency_subelement varchar2(30);
35: l_as_of_date date;
36: l_Benefit_Amount ghr_pa_request_extra_info.rei_information7%type;
37: l_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
38: l_citizenship ghr_pa_requests.CITIZENSHIP%type;
39: l_credit_mil_svc per_people_extra_info.pei_information5%type;
40: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;

Line 61: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%type;

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

Line 86: l_rating_of_record_level ghr_pa_request_extra_info.rei_information5%type;

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

Line 87: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%type;

83: l_prior_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
84: l_Production_Date date;
85: l_Race_National_Region per_people_extra_info.pei_information5%type;
86: l_rating_of_record_level ghr_pa_request_extra_info.rei_information5%type;
87: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%type;
88: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%type;
89: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117
90: l_retain_grade per_people_extra_info.pei_information3%type;
91: l_retain_pay_plan per_people_extra_info.pei_information5%type;

Line 88: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%type;

84: l_Production_Date date;
85: l_Race_National_Region per_people_extra_info.pei_information5%type;
86: l_rating_of_record_level ghr_pa_request_extra_info.rei_information5%type;
87: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%type;
88: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%type;
89: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117
90: l_retain_grade per_people_extra_info.pei_information3%type;
91: l_retain_pay_plan per_people_extra_info.pei_information5%type;
92: l_retain_step per_people_extra_info.pei_information4%type;

Line 89: l_rating_of_record_per_starts ghr_pa_request_extra_info.rei_information19%type; --4753117

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

Line 282: from ghr_pa_request_extra_info

278: WHERE equivalent_pay_plan = 'FW'
279: AND pay_plan = p_pay_plan;
280: cursor c_740_rei is
281: select count(rei_information3) rei_count
282: from ghr_pa_request_extra_info
283: where pa_request_id = p_pa_request_rec.pa_request_id
284: and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
285: and rei_information5 = 'Y'
286: and nvl(rei_information30,hr_api.g_varchar2) <> 'Original RPA';

Line 321: FROM ghr_pa_request_extra_info

317:
318: CURSOR cur_temp_step
319: IS
320: SELECT rei_information3 temp_step
321: FROM ghr_pa_request_extra_info
322: WHERE pa_request_id = p_pa_request_rec.pa_request_id
323: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
324:
325:

Line 351: FROM ghr_pa_request_extra_info

347: --
348: CURSOR cur_rei_poi(p_par_id in NUMBER)
349: IS
350: SELECT rei_information5
351: FROM ghr_pa_request_extra_info
352: WHERE pa_request_id=p_par_id
353: AND information_type='GHR_US_PAR_REALIGNMENT';
354:
355: target_poi ghr_pa_requests.personnel_office_id%type;