APPS.GHR_SF113_A dependencies on GHR_NATURE_OF_ACTIONS

Line 34: l_code GHR_NATURE_OF_ACTIONS.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;
38: l_people_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;

Line 1440: GHR_NATURE_OF_ACTIONS gnoa,

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
1444:

Line 1523: GHR_NATURE_OF_ACTIONS gnoa,

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
1527: