DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PER_ALL_PEOPLE_F

Line 4872: from per_all_people_f ppf

4868: first_name || ' ' ||
4869: decode(nvl(length(ltrim(rtrim(middle_names))),0), 0, null,
4870: upper(substr(middle_names,1,1)) || '. ' ) ||
4871: pre_name_adjunct || last_name || ' '|| suffix))
4872: from per_all_people_f ppf
4873: where ppf.person_id =
4874: (select person_id from per_all_assignments_f paf
4875: where assignment_id = cp_assignment_id
4876: and cp_effective_date between paf.effective_start_date