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 28: l_duty_station_code GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%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;
32: l_first_action_la_code1 GHR_PA_REQUESTS.FIRST_ACTION_LA_CODE1%TYPE;

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

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

Line 368: GHR_DUTY_STATIONS_F hds,

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

Line 1145: GHR_DUTY_STATIONS_F hds,

1141: per_assignment_status_types past,
1142: GHR_PAYROLL gp,
1143: HR_ALL_POSITIONS_F pp,
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

Line 1443: GHR_DUTY_STATIONS_F hds

1439: GHR_PA_REQUESTS gpr,
1440: GHR_NATURE_OF_ACTIONS gnoa,
1441: HR_ALL_POSITIONS_F pp,
1442: PER_POSITION_DEFINITIONS ppd,
1443: GHR_DUTY_STATIONS_F hds
1444:
1445: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1446: ,'SEGMENT2',ppd.segment2
1447: ,'SEGMENT3',ppd.segment3

Line 1526: GHR_DUTY_STATIONS_F hds

1522: GHR_PA_REQUESTS gpr,
1523: GHR_NATURE_OF_ACTIONS gnoa,
1524: HR_ALL_POSITIONS_F pp,
1525: PER_POSITION_DEFINITIONS ppd,
1526: GHR_DUTY_STATIONS_F hds
1527:
1528: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1529: ,'SEGMENT2',ppd.segment2
1530: ,'SEGMENT3',ppd.segment3