80: AND ptu.person_type_id = ppt.person_type_id
81: AND ppt.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'CWK_APL'));
82:
83: ln_notification_id NUMBER;
84: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
85: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
86: from_name per_all_people_f.GLOBAL_NAME%TYPE;
87: to_name per_all_people_f.GLOBAL_NAME%TYPE;
88: from_role_not_exists EXCEPTION;
81: AND ppt.system_person_type IN ('EMP', 'CWK', 'EMP_APL', 'CWK_APL'));
82:
83: ln_notification_id NUMBER;
84: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
85: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
86: from_name per_all_people_f.GLOBAL_NAME%TYPE;
87: to_name per_all_people_f.GLOBAL_NAME%TYPE;
88: from_role_not_exists EXCEPTION;
89: to_role_not_exists EXCEPTION;