DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on GHR_PA_HISTORY

Line 34: l_ass_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%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;
38: l_people1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;

Line 35: l_pos_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%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;
38: l_people1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
39: l_status varchar2(1);

Line 36: l_pos1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%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;
38: l_people1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
39: l_status varchar2(1);
40: -- l_susp_flag varchar2(1) := 'N';

Line 37: l_people_eff_date GHR_PA_HISTORY.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;
38: l_people1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
39: l_status varchar2(1);
40: -- l_susp_flag varchar2(1) := 'N';
41: l_susp_flag varchar2(1);

Line 38: l_people1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%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;
38: l_people1_eff_date GHR_PA_HISTORY.EFFECTIVE_DATE%TYPE;
39: l_status varchar2(1);
40: -- l_susp_flag varchar2(1) := 'N';
41: l_susp_flag varchar2(1);
42: l_lwop_nte_date date;