APPS.PER_PMP_MASS_NOTIFICATION dependencies on PER_PERF_MGMT_PLANS

Line 397: l_admin_person_id per_perf_mgmt_plans.administrator_person_id%TYPE;

393: IS
394: item_key wf_notifications.item_key%TYPE;
395: --item_type wf_notifications.item_type%type default 'HRWPM';
396: l_administrator_role wf_local_roles.NAME%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)

Line 422: FROM per_perf_mgmt_plans

418:
419: -- get administrartor role as notification sender
420: SELECT administrator_person_id
421: INTO l_admin_person_id
422: FROM per_perf_mgmt_plans
423: WHERE plan_id = p_plan_id;
424:
425: OPEN get_wf_role (l_admin_person_id);
426: