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