DBA Data[Home] [Help]

APPS.PA_WORKFLOW_HISTORY dependencies on PER_ALL_PEOPLE_F

Line 74: per_all_people_f papf

70: union all
71: select fu.user_name, papf.full_name, papf.email_address
72: from fnd_user fu,
73: hz_parties hp,
74: per_all_people_f papf
75: where 'PER:' || fu.employee_id = hp.orig_system_reference
76: and fu.user_name = l_user_name
77: and trunc(sysdate)
78: between papf.EFFECTIVE_START_DATE