APPS.HR_US_REPORTS dependencies on PER_PEOPLE_F

Line 163: per_people_f ppf

159:
160: CURSOR c_get_p_payee IS
161: SELECT SUBSTR(INITCAP(RTRIM(ppf.title)||' '||RTRIM(ppf.first_name)||' '||RTRIM(ppf.last_name)),1,60)
162: FROM per_addresses addr,
163: per_people_f ppf
164: WHERE ppf.person_id = IN_payee_id
165: AND ppf.business_group_id+0 = IN_business_group_id
166: AND IN_payment_date BETWEEN ppf.effective_start_date
167: AND ppf.effective_end_date

Line 311: v_contact_name per_people_f.full_name%TYPE;

307: p_contact_title out nocopy varchar2,
308: p_contact_phone out nocopy varchar2
309: ) IS
310: --
311: v_contact_name per_people_f.full_name%TYPE;
312: v_contact_title per_jobs.name%TYPE;
313: v_contact_phone per_people_f.work_telephone%TYPE;
314:
315: CURSOR c_new_hire_record IS

Line 313: v_contact_phone per_people_f.work_telephone%TYPE;

309: ) IS
310: --
311: v_contact_name per_people_f.full_name%TYPE;
312: v_contact_title per_jobs.name%TYPE;
313: v_contact_phone per_people_f.work_telephone%TYPE;
314:
315: CURSOR c_new_hire_record IS
316: Select ppf.full_name,
317: job.name,

Line 320: per_people_f ppf,

316: Select ppf.full_name,
317: job.name,
318: ppf.work_telephone
319: From
320: per_people_f ppf,
321: per_assignments_f paf,
322: per_jobs job
323: Where
324: ppf.person_id = p_person_id

Line 847: FROM per_people_f ppf

843: begin
844: hr_utility.set_location('hr_us_reports.get_person_name',5);
845: SELECT distinct full_name
846: INTO l_person_name
847: FROM per_people_f ppf
848: WHERE person_id = p_person_id
849: AND ppf.effective_start_date =
850: (select max(effective_start_date)
851: from per_people_f ppf1

Line 851: from per_people_f ppf1

847: FROM per_people_f ppf
848: WHERE person_id = p_person_id
849: AND ppf.effective_start_date =
850: (select max(effective_start_date)
851: from per_people_f ppf1
852: where ppf1.person_id = ppf.person_id);
853: --
854: exception when NO_DATA_FOUND then RETURN NULL;
855: end;

Line 914: FROM per_people_f ppe,

910: elsif l_action_type = 'Q' then
911: begin
912: SELECT ppa.display_run_number || '-' || ppe.full_name
913: INTO l_payroll_action_name
914: FROM per_people_f ppe,
915: per_all_assignments_f pas,
916: pay_assignment_actions paa,
917: pay_payroll_actions ppa
918: WHERE ppe.person_id = pas.person_id