APPS.PAY_US_ACTION_ARCH dependencies on PER_ALL_PEOPLE_F

Line 5869: from per_all_people_f ppf

5865: first_name || ' ' ||
5866: decode(nvl(length(ltrim(rtrim(middle_names))),0), 0, null,
5867: upper(substr(middle_names,1,1)) || '. ' ) ||
5868: pre_name_adjunct || last_name || ' '|| suffix))
5869: from per_all_people_f ppf
5870: where ppf.person_id =
5871: (select person_id from per_all_assignments_f paf
5872: where assignment_id = cp_assignment_id
5873: and cp_effective_date between paf.effective_start_date

Line 6863: per_all_people_f ppf

6859: addr.region_2,
6860: addr.postal_code
6861: from
6862: per_addresses addr,
6863: per_all_people_f ppf
6864: where
6865: ppf.person_id = cp_payee_id
6866: and ppf.business_group_id = cp_business_group_id
6867: and cp_payment_date between ppf.effective_start_date