APPS.HXC_APPROVAL_WF_HELPER dependencies on PER_ALL_PEOPLE_F

Line 213: l_full_name per_all_people_f.full_name%type;

209: is
210:
211: l_system_id wf_local_roles.orig_system_id%type;
212: l_original_system wf_local_roles.orig_system%type;
213: l_full_name per_all_people_f.full_name%type;
214: l_display_name wf_local_roles.display_name%type;
215: l_proc constant varchar2(61) := g_pkg ||'find_full_name_from_role';
216:
217: CURSOR c_get_original_system(p_role_name in wf_local_roles.name%type)

Line 227: from per_all_people_f

223: CURSOR c_get_name_ppf(p_system_id in wf_local_roles.orig_system_id%type,
224: p_effective_date in date)
225: is
226: select full_name
227: from per_all_people_f
228: where person_id = p_system_id
229: and p_effective_date between effective_start_date and effective_end_date;
230:
231:

Line 248: --If the original system is PER then we can do a direct query against PER_ALL_PEOPLE_F to fetch the full name.

244:
245: if g_debug then
246: hr_utility.set_location(l_proc, 20);
247: end if;
248: --If the original system is PER then we can do a direct query against PER_ALL_PEOPLE_F to fetch the full name.
249: open c_get_name_ppf(l_system_id, p_effective_date);
250: fetch c_get_name_ppf into l_full_name;
251: close c_get_name_ppf;
252: END if;

Line 1039: l_worker_full_name per_all_people_f.full_name%type;

1035: l_total_hours number ;
1036: l_premium_hours number ;
1037: l_non_worked_hours number ;
1038: l_worker_role wf_local_roles.name%type;
1039: l_worker_full_name per_all_people_f.full_name%type;
1040: l_preparer_role wf_local_roles.name%type;
1041: l_preparer_full_name per_all_people_f.full_name%type;
1042: l_fyi_subject varchar2(4000);
1043: l_description varchar2(4000);

Line 1041: l_preparer_full_name per_all_people_f.full_name%type;

1037: l_non_worked_hours number ;
1038: l_worker_role wf_local_roles.name%type;
1039: l_worker_full_name per_all_people_f.full_name%type;
1040: l_preparer_role wf_local_roles.name%type;
1041: l_preparer_full_name per_all_people_f.full_name%type;
1042: l_fyi_subject varchar2(4000);
1043: l_description varchar2(4000);
1044: l_tc_url varchar2(1000);
1045: l_resource_id hxc_time_building_blocks.resource_id%type;

Line 1058: l_apr_name per_all_people_f.full_name%type;

1054: l_supervisor_role wf_local_roles.name%type;
1055: l_tc_id number;
1056: l_tc_ovn number;
1057: l_apr_person_id number;
1058: l_apr_name per_all_people_f.full_name%type;
1059: l_supervisor_name per_all_people_f.full_name%type;
1060: l_supervisor_id number;
1061: l_proc constant varchar2(61) :=g_pkg||'Prepare Notifications';
1062:

Line 1059: l_supervisor_name per_all_people_f.full_name%type;

1055: l_tc_id number;
1056: l_tc_ovn number;
1057: l_apr_person_id number;
1058: l_apr_name per_all_people_f.full_name%type;
1059: l_supervisor_name per_all_people_f.full_name%type;
1060: l_supervisor_id number;
1061: l_proc constant varchar2(61) :=g_pkg||'Prepare Notifications';
1062:
1063: CURSOR c_tc_info(