APPS.GHR_SF113_A dependencies on GHR_NATURE_OF_ACTIONS

Line 33: l_code GHR_NATURE_OF_ACTIONS.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;
34: l_ass_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
35: l_pos_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
36: l_pos1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
37: l_people_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;

Line 1430: GHR_NATURE_OF_ACTIONS gnoa,

1426: gpr.effective_date
1427:
1428: FROM GHR_SF113_V v,
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:

Line 1513: GHR_NATURE_OF_ACTIONS gnoa,

1509: gpr.effective_date
1510:
1511: FROM GHR_SF113_V v,
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: