22: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
23: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;
24: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;
25: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;
26: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;
27: l_duty_station_code GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
28: l_duty_station GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
29: l_msa_code GHR_DUTY_STATIONS_F.MSA_CODE%TYPE;
30: l_noa_family_code GHR_PA_REQUESTS.NOA_FAMILY_CODE%TYPE;
368: HR_LOCATION_EXTRA_INFO hlei,
369: PER_POSITION_DEFINITIONS ppd,
370: HR_ALL_POSITIONS_F pp,
371: PER_GRADES pg,
372: PER_GRADE_DEFINITIONS pgd
373: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
374: ,'SEGMENT2',ppd.segment2
375: ,'SEGMENT3',ppd.segment3
376: ,'SEGMENT4',ppd.segment4
1134: PER_POSITION_DEFINITIONS ppd,
1135: GHR_DUTY_STATIONS_F hds,
1136: HR_LOCATION_EXTRA_INFO hlei,
1137: PER_GRADES pg,
1138: PER_GRADE_DEFINITIONS pgd
1139: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1140: ,'SEGMENT2',ppd.segment2
1141: ,'SEGMENT3',ppd.segment3
1142: ,'SEGMENT4',ppd.segment4