APPS.HR_US_REPORTS dependencies on PER_PEOPLE_F

Line 171: per_people_f ppf

167:
168: CURSOR c_get_p_payee IS
169: SELECT SUBSTR(INITCAP(RTRIM(ppf.title)||' '||RTRIM(ppf.first_name)||' '||RTRIM(ppf.last_name)),1,60)
170: FROM per_addresses addr,
171: per_people_f ppf
172: WHERE ppf.person_id = IN_payee_id
173: AND ppf.business_group_id+0 = IN_business_group_id
174: AND IN_payment_date BETWEEN ppf.effective_start_date
175: AND ppf.effective_end_date

Line 319: v_contact_name per_people_f.full_name%TYPE;

315: p_contact_title out nocopy varchar2,
316: p_contact_phone out nocopy varchar2
317: ) IS
318: --
319: v_contact_name per_people_f.full_name%TYPE;
320: v_contact_title per_jobs.name%TYPE;
321: v_contact_phone per_people_f.work_telephone%TYPE;
322:
323: CURSOR c_new_hire_record IS

Line 321: v_contact_phone per_people_f.work_telephone%TYPE;

317: ) IS
318: --
319: v_contact_name per_people_f.full_name%TYPE;
320: v_contact_title per_jobs.name%TYPE;
321: v_contact_phone per_people_f.work_telephone%TYPE;
322:
323: CURSOR c_new_hire_record IS
324: Select ppf.full_name,
325: job.name,

Line 328: per_people_f ppf,

324: Select ppf.full_name,
325: job.name,
326: ppf.work_telephone
327: From
328: per_people_f ppf,
329: per_assignments_f paf,
330: per_jobs job
331: Where
332: ppf.person_id = p_person_id

Line 865: FROM per_people_f ppf

861: begin
862: hr_utility.set_location('hr_us_reports.get_person_name',5);
863: SELECT distinct full_name
864: INTO l_person_name
865: FROM per_people_f ppf
866: WHERE person_id = p_person_id
867: AND ppf.effective_start_date =
868: (select max(effective_start_date)
869: from per_people_f ppf1

Line 869: from per_people_f ppf1

865: FROM per_people_f ppf
866: WHERE person_id = p_person_id
867: AND ppf.effective_start_date =
868: (select max(effective_start_date)
869: from per_people_f ppf1
870: where ppf1.person_id = ppf.person_id);
871: --
872: exception when NO_DATA_FOUND then RETURN NULL;
873: end;

Line 932: FROM per_people_f ppe,

928: elsif l_action_type = 'Q' then
929: begin
930: SELECT ppa.display_run_number || '-' || ppe.full_name
931: INTO l_payroll_action_name
932: FROM per_people_f ppe,
933: per_all_assignments_f pas,
934: pay_assignment_actions paa,
935: pay_payroll_actions ppa
936: WHERE ppe.person_id = pas.person_id