640: FROM per_all_people_f
641: WHERE person_id = p_person_id
642: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
643:
644: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
645: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
646: from_name per_all_people_f.GLOBAL_NAME%TYPE;
647: appraisee_name per_all_people_f.GLOBAL_NAME%TYPE;
648: msg_name varchar2(100);
641: WHERE person_id = p_person_id
642: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
643:
644: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
645: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;
646: from_name per_all_people_f.GLOBAL_NAME%TYPE;
647: appraisee_name per_all_people_f.GLOBAL_NAME%TYPE;
648: msg_name varchar2(100);
649: BEGIN