APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_PERF_MGMT_PLANS

Line 295: l_admin_person_id per_perf_mgmt_plans.ADMINISTRATOR_PERSON_ID%TYPE;

291: ,p_message_body IN VARCHAR2) IS
292: item_key wf_notifications.item_key%TYPE;
293: --item_type wf_notifications.item_type%type default 'HRWPM';
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

Line 315: SELECT ADMINISTRATOR_PERSON_ID INTO l_admin_person_id FROM per_perf_mgmt_plans WHERE plan_id =p_plan_id;

311:
312: BEGIN
313: WRITE('Inside Notify');
314: -- get administrartor role as notification sender
315: SELECT ADMINISTRATOR_PERSON_ID INTO l_admin_person_id FROM per_perf_mgmt_plans WHERE plan_id =p_plan_id;
316: OPEN get_wf_role(l_admin_person_id);
317: fetch get_wf_role into l_administrator_role;
318: close get_wf_role;
319: WRITE('admin role (From Role) : ' || l_administrator_role);