APPS.GHR_WF_WGI_PKG dependencies on PER_PEOPLE_F

Line 61: l_full_name per_people_f.full_name%TYPE;

57: l_position_id ghr_pa_requests.from_position_id%TYPE;
58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;

Line 91: from per_people_f ppf

87: --
88: --
89: Cursor c_user_full_name is
90: Select ppf.full_name
91: from per_people_f ppf
92: where ppf.person_id =
93: (select employee_id
94: from fnd_user
95: where user_name = l_user_name

Line 432: (p_person_id in per_people_f.person_id%type,

428: -- ----------------------------------------------------------------------------
429: -- |-----------------------------< get_next_approver >------------------------|
430: -- ----------------------------------------------------------------------------
431: function get_next_approver
432: (p_person_id in per_people_f.person_id%type,
433: p_effective_date in ghr_pa_requests.effective_date%TYPE
434: )
435: return ghr_pa_routing_history.user_name%TYPE is
436: --

Line 444: ,per_people_f ppf

440: --
441: cursor csr_pa is
442: select substr(usr.user_name,1,30) user_name
443: from per_assignments_f paf
444: ,per_people_f ppf
445: ,fnd_user usr
446: where paf.person_id = l_in_person_id
447: and paf.primary_flag = 'Y'
448: and p_effective_date

Line 1998: l_full_name per_people_f.full_name%TYPE;

1994: l_position_id ghr_pa_requests.from_position_id%TYPE;
1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;