APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_ALL_PEOPLE_F

Line 401: CURSOR get_wf_role (p_person_id per_all_people_f.person_id%TYPE)

397: l_admin_person_id per_perf_mgmt_plans.administrator_person_id%TYPE;
398: to_role wf_local_roles.NAME%TYPE;
399: l_message_body VARCHAR2 (4000);
400:
401: CURSOR get_wf_role (p_person_id per_all_people_f.person_id%TYPE)
402: IS
403: SELECT NAME
404: FROM wf_roles
405: WHERE orig_system_id = p_person_id AND orig_system = 'PER';