61: and ppse.business_group_id = sup.business_group_id
62: and ppse.parent_position_id = sup.position_id;
63:
64: ln_notification_id number;
65: from_role wf_local_roles.name%TYPE default null;
66: to_role wf_local_roles.name%TYPE default null;
67: from_name per_all_people_f.global_name%TYPE;
68: to_name per_all_people_f.global_name%TYPE;
69: FROM_ROLE_NOT_EXISTS exception;
62: and ppse.parent_position_id = sup.position_id;
63:
64: ln_notification_id number;
65: from_role wf_local_roles.name%TYPE default null;
66: to_role wf_local_roles.name%TYPE default null;
67: from_name per_all_people_f.global_name%TYPE;
68: to_name per_all_people_f.global_name%TYPE;
69: FROM_ROLE_NOT_EXISTS exception;
70: TO_ROLE_NOT_EXISTS exception;