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.

[Home] [Help]

APPS.GHR_GHRWS52L dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 35: l_Benefit_Amount ghr_pa_request_extra_info.rei_information7%type;

31: l_Agency_Code varchar2(30);
32: -- l_Agency varchar2(30);
33: l_agency_subelement varchar2(30);
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;

Line 60: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%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;
64: -- l_Occupation_code per_position_extra_info.poei_information6%type;

Line 85: l_rating_of_record_level ghr_pa_request_extra_info.rei_information5%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
89: l_retain_grade per_people_extra_info.pei_information3%type;

Line 86: l_rating_of_record_pattern ghr_pa_request_extra_info.rei_information4%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
89: l_retain_grade per_people_extra_info.pei_information3%type;
90: l_retain_pay_plan per_people_extra_info.pei_information5%type;

Line 87: l_rating_of_record_period ghr_pa_request_extra_info.rei_information6%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
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;

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

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
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;

Line 277: from ghr_pa_request_extra_info

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

Line 316: FROM ghr_pa_request_extra_info

312:
313: CURSOR cur_temp_step
314: IS
315: SELECT rei_information3 temp_step
316: FROM ghr_pa_request_extra_info
317: WHERE pa_request_id = p_pa_request_rec.pa_request_id
318: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
319:
320:

Line 346: FROM ghr_pa_request_extra_info

342: --
343: CURSOR cur_rei_poi(p_par_id in NUMBER)
344: IS
345: SELECT rei_information5
346: FROM ghr_pa_request_extra_info
347: WHERE pa_request_id=p_par_id
348: AND information_type='GHR_US_PAR_REALIGNMENT';
349:
350: target_poi ghr_pa_requests.personnel_office_id%type;