APPS.GHR_SS_RPA_CREATION dependencies on GHR_PA_REQUESTS_PKG2

Line 93: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

89: open chk_fegli_exists;
90: fetch chk_fegli_exists into l_curr_fegli,l_pa_request_id,l_object_version_number,
91: l_employee_last_name,l_employee_first_name,l_employee_middle_names;
92: l_full_name := l_employee_last_name||','|| l_employee_first_name||' '|| l_employee_middle_names;
93: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
94: (p_person_id => p_person_id,
95: p_effective_date => p_effective_date);
96: if chk_fegli_exists%notfound then
97:

Line 321: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

317: EXIT;
318: END LOOP;
319:
320: l_full_name := l_sf52_rec.employee_last_name||','|| l_sf52_rec.employee_first_name||' '|| l_sf52_rec.employee_middle_names;
321: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
322: (p_person_id => l_sf52_rec.person_id,
323: p_effective_date => l_sf52_rec.effective_date);
324:
325: