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_PA_REQUESTS

Line 31: l_noa_family_code GHR_PA_REQUESTS.NOA_FAMILY_CODE%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;
35: l_ass_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;

Line 32: l_first_action_la_code1 GHR_PA_REQUESTS.FIRST_ACTION_LA_CODE1%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;
35: l_ass_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
36: l_pos_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;

Line 33: l_effective_date GHR_PA_REQUESTS.EFFECTIVE_DATE%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;
35: l_ass_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
36: l_pos_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
37: l_pos1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;

Line 1439: GHR_PA_REQUESTS gpr,

1435: hds.msa_code,
1436: gpr.effective_date
1437:
1438: FROM GHR_SF113_V v,
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

Line 1488: -- Bug 3792359 Added condition linking sf_113v and ghr_pa_requests on the column effective date

1484: AND (TRUNC(p_rpt_date) BETWEEN pp.effective_start_date AND pp.effective_end_date)
1485: AND (pp.position_definition_id = ppd.position_definition_id)
1486: AND (gpr.person_id = v.person_id);
1487:
1488: -- Bug 3792359 Added condition linking sf_113v and ghr_pa_requests on the column effective date
1489: -- end date incremented by 1 to include suspended employees.
1490:
1491: -- Bug 3264666 Anil
1492:

Line 1522: GHR_PA_REQUESTS gpr,

1518: hds.msa_code,
1519: gpr.effective_date
1520:
1521: FROM GHR_SF113_V v,
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