DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on PER_GRADE_DEFINITIONS

Line 26: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;

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;

Line 372: PER_GRADE_DEFINITIONS pgd

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

Line 1138: PER_GRADE_DEFINITIONS pgd

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