APPS.HR_WPM_NTF_UTIL dependencies on PER_ALL_PEOPLE_F

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

9: )
10: RETURN NUMBER
11: IS
12: -- to be clarified for orig_system
13: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)
14: IS
15: SELECT wf.NAME role_name
16: FROM wf_roles wf
17: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;

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

15: SELECT wf.NAME role_name
16: FROM wf_roles wf
17: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;
18:
19: CURSOR get_global_name (p_person_id per_all_people_f.person_id%TYPE)
20: IS
21: SELECT NVL (GLOBAL_NAME, first_name || ', ' || last_name)
22: FROM per_all_people_f
23: WHERE person_id = p_person_id

Line 22: FROM per_all_people_f

18:
19: CURSOR get_global_name (p_person_id per_all_people_f.person_id%TYPE)
20: IS
21: SELECT NVL (GLOBAL_NAME, first_name || ', ' || last_name)
22: FROM per_all_people_f
23: WHERE person_id = p_person_id
24: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
25:
26: CURSOR get_scorecard_info (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

Line 86: from_name per_all_people_f.GLOBAL_NAME%TYPE;

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;
90: l_sc_info per_personal_scorecards%ROWTYPE;

Line 87: to_name per_all_people_f.GLOBAL_NAME%TYPE;

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;
90: l_sc_info per_personal_scorecards%ROWTYPE;
91: no_score_card_with_this_id EXCEPTION;

Line 94: mgr_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;

90: l_sc_info per_personal_scorecards%ROWTYPE;
91: no_score_card_with_this_id EXCEPTION;
92: lv_subject VARCHAR2 (200) DEFAULT NULL;
93: tlnt_mgmt_rel_apps_fn VARCHAR2 (200) DEFAULT NULL;
94: mgr_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
95: sc_person_id per_personal_scorecards.person_id%TYPE DEFAULT NULL;
96: from_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
98: mesg_name fnd_new_messages.message_text%TYPE DEFAULT NULL;

Line 96: from_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;

92: lv_subject VARCHAR2 (200) DEFAULT NULL;
93: tlnt_mgmt_rel_apps_fn VARCHAR2 (200) DEFAULT NULL;
94: mgr_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
95: sc_person_id per_personal_scorecards.person_id%TYPE DEFAULT NULL;
96: from_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
98: mesg_name fnd_new_messages.message_text%TYPE DEFAULT NULL;
99: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
100: l_top_supervisor_id per_perf_mgmt_plans.supervisor_id%TYPE;

Line 97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;

93: tlnt_mgmt_rel_apps_fn VARCHAR2 (200) DEFAULT NULL;
94: mgr_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
95: sc_person_id per_personal_scorecards.person_id%TYPE DEFAULT NULL;
96: from_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
97: to_person_id per_all_people_f.person_id%TYPE DEFAULT NULL;
98: mesg_name fnd_new_messages.message_text%TYPE DEFAULT NULL;
99: l_hier_code per_perf_mgmt_plans.hierarchy_type_code%TYPE;
100: l_top_supervisor_id per_perf_mgmt_plans.supervisor_id%TYPE;
101: l_top_sup_asg_id per_perf_mgmt_plans.supervisor_assignment_id%TYPE;