APPS.GHR_API dependencies on PER_ALL_PEOPLE_F

Line 53: from per_all_people_f per,per_person_types ppt

49:
50: --
51: Cursor c_per_type(per_id number,eff_date date) is
52: Select ppt.system_person_type
53: from per_all_people_f per,per_person_types ppt
54: where per.person_id = per_id
55: and trunc(eff_date) between per.effective_start_date
56: and per.effective_end_date
57: and per.person_type_id = ppt.person_type_id;

Line 111: from per_all_people_f per

107: l_person_type per_person_types.system_person_type%type;
108: --
109: cursor c_person (per_id number, eff_date date) is
110: select per.business_group_id
111: from per_all_people_f per
112: where per.person_id = per_id
113: and trunc(eff_date) between per.effective_start_date
114: and per.effective_end_date;
115: --

Line 184: l_people_data per_all_people_f%rowtype;

180: ,p_business_group_id OUT NOCOPY per_business_groups.business_group_id%type
181: ) is
182: --
183: l_result_code varchar2(30);
184: l_people_data per_all_people_f%rowtype;
185: l_assignment_data per_all_assignments_f%rowtype;
186: l_proc varchar2(72) := g_package||'retrieve_business_group_id';
187: Begin
188: if p_person_id is not null then

Line 2708: from per_all_people_f ppf,

2704: --
2705: -- Cursor to get person type
2706: cursor c_person_type is
2707: select system_person_type
2708: from per_all_people_f ppf,
2709: per_person_types ppt
2710: where ppf.person_id = p_person_id
2711: and ppt.person_type_id = ppf.person_type_id;
2712: --