DBA Data[Home] [Help]

APPS.HR_APPRAISALS_UTIL_SS dependencies on WF_LOCAL_ROLES

Line 644: from_role wf_local_roles.NAME%TYPE DEFAULT NULL;

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);

Line 645: to_role wf_local_roles.NAME%TYPE DEFAULT NULL;

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