APPS.HR_APPRAISALS_UTIL_SS dependencies on PER_ALL_PEOPLE_F

Line 631: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)

627: procedure send_notification( p_fromPersonId VARCHAR2, p_toPersonId VARCHAR2,p_comment VARCHAR2,p_mainAprId VARCHAR2,p_actionType VARCHAR2) AS
628: ln_notification_id NUMBER;
629: ln_MAnotification_id NUMBER;
630:
631: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)
632: IS
633: SELECT wf.NAME role_name
634: FROM wf_roles wf
635: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;

Line 637: CURSOR get_global_name (p_person_id per_all_people_f.person_id%TYPE)

633: SELECT wf.NAME role_name
634: FROM wf_roles wf
635: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;
636:
637: CURSOR get_global_name (p_person_id per_all_people_f.person_id%TYPE)
638: IS
639: SELECT NVL (GLOBAL_NAME, first_name || ', ' || last_name)
640: FROM per_all_people_f
641: WHERE person_id = p_person_id

Line 640: FROM per_all_people_f

636:
637: CURSOR get_global_name (p_person_id per_all_people_f.person_id%TYPE)
638: IS
639: SELECT NVL (GLOBAL_NAME, first_name || ', ' || last_name)
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;

Line 646: from_name per_all_people_f.GLOBAL_NAME%TYPE;

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
650:

Line 647: appraisee_name per_all_people_f.GLOBAL_NAME%TYPE;

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
650:
651: OPEN get_role (p_fromPersonId);