[Home] [Help]
APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_ALL_PEOPLE_F
Line 298: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
294: l_administrator_role wf_local_roles.name%TYPE;
295: l_admin_person_id per_perf_mgmt_plans.ADMINISTRATOR_PERSON_ID%TYPE;
296: to_role wf_local_roles.name%TYPE;
297: l_message_body VARCHAR2(4000);
298: cursor get_wf_role(p_person_id per_all_people_f.person_id%TYPE)
299: is
300: select name from wf_roles
301: where orig_system_id = p_person_id
302: and orig_system = 'PER';