DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on PER_GRADE_DEFINITIONS

Line 27: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;

23: l_appointment PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION3%TYPE;
24: l_emp_type PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION4%TYPE;
25: l_cur_appt1 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION8%TYPE;
26: l_cur_appt2 PER_PEOPLE_EXTRA_INFO.PEI_INFORMATION9%TYPE;
27: l_pay_plan PER_GRADE_DEFINITIONS.SEGMENT1%TYPE;
28: l_duty_station_code GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
29: l_duty_station GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
30: l_msa_code GHR_DUTY_STATIONS_F.MSA_CODE%TYPE;
31: l_noa_family_code GHR_PA_REQUESTS.NOA_FAMILY_CODE%TYPE;

Line 373: PER_GRADE_DEFINITIONS pgd

369: HR_LOCATION_EXTRA_INFO hlei,
370: PER_POSITION_DEFINITIONS ppd,
371: HR_ALL_POSITIONS_F pp,
372: PER_GRADES pg,
373: PER_GRADE_DEFINITIONS pgd
374: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
375: ,'SEGMENT2',ppd.segment2
376: ,'SEGMENT3',ppd.segment3
377: ,'SEGMENT4',ppd.segment4

Line 1148: PER_GRADE_DEFINITIONS pgd

1144: PER_POSITION_DEFINITIONS ppd,
1145: GHR_DUTY_STATIONS_F hds,
1146: HR_LOCATION_EXTRA_INFO hlei,
1147: PER_GRADES pg,
1148: PER_GRADE_DEFINITIONS pgd
1149: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1150: ,'SEGMENT2',ppd.segment2
1151: ,'SEGMENT3',ppd.segment3
1152: ,'SEGMENT4',ppd.segment4