DBA Data[Home] [Help]

APPS.PA_WORKFLOW_HISTORY dependencies on PER_ALL_PEOPLE_F

Line 69: per_all_people_f papf

65: union all
66: select fu.user_name, papf.full_name, papf.email_address
67: from fnd_user fu,
68: hz_parties hp,
69: per_all_people_f papf
70: where 'PER:' || fu.employee_id = hp.orig_system_reference
71: and fu.user_name = l_user_name
72: and trunc(sysdate)
73: between papf.EFFECTIVE_START_DATE