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_SF113_A dependencies on GHR_DUTY_STATIONS_F

Line 27: l_duty_station_code GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%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;
31: l_first_action_la_code1 GHR_PA_REQUESTS.FIRST_ACTION_LA_CODE1%TYPE;

Line 28: l_duty_station GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%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;
31: l_first_action_la_code1 GHR_PA_REQUESTS.FIRST_ACTION_LA_CODE1%TYPE;
32: l_effective_date GHR_PA_REQUESTS.EFFECTIVE_DATE%TYPE;

Line 29: l_msa_code GHR_DUTY_STATIONS_F.MSA_CODE%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;
31: l_first_action_la_code1 GHR_PA_REQUESTS.FIRST_ACTION_LA_CODE1%TYPE;
32: l_effective_date GHR_PA_REQUESTS.EFFECTIVE_DATE%TYPE;
33: l_code GHR_NATURE_OF_ACTIONS.CODE%TYPE;

Line 367: GHR_DUTY_STATIONS_F hds,

363: pp.date_effective,
364: pp.date_end ,
365: pp.permanent_temporary_flag
366: FROM GHR_SF113_V v,
367: GHR_DUTY_STATIONS_F hds,
368: HR_LOCATION_EXTRA_INFO hlei,
369: PER_POSITION_DEFINITIONS ppd,
370: HR_ALL_POSITIONS_F pp,
371: PER_GRADES pg,

Line 1135: GHR_DUTY_STATIONS_F hds,

1131: per_assignment_status_types past,
1132: GHR_PAYROLL gp,
1133: HR_ALL_POSITIONS_F pp,
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

Line 1433: GHR_DUTY_STATIONS_F hds

1429: GHR_PA_REQUESTS gpr,
1430: GHR_NATURE_OF_ACTIONS gnoa,
1431: HR_ALL_POSITIONS_F pp,
1432: PER_POSITION_DEFINITIONS ppd,
1433: GHR_DUTY_STATIONS_F hds
1434:
1435: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1436: ,'SEGMENT2',ppd.segment2
1437: ,'SEGMENT3',ppd.segment3

Line 1516: GHR_DUTY_STATIONS_F hds

1512: GHR_PA_REQUESTS gpr,
1513: GHR_NATURE_OF_ACTIONS gnoa,
1514: HR_ALL_POSITIONS_F pp,
1515: PER_POSITION_DEFINITIONS ppd,
1516: GHR_DUTY_STATIONS_F hds
1517:
1518: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1519: ,'SEGMENT2',ppd.segment2
1520: ,'SEGMENT3',ppd.segment3