DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on PER_ALL_PEOPLE_F

Line 633: per_all_people_f papf

629: union
630: select fu.user_name, hp.party_name, hp.email_address
631: from fnd_user fu,
632: hz_parties hp,
633: per_all_people_f papf
634: where
635: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
636: AND 'PER:' = Substr(hp.orig_system_reference,1,4) -- 'PER:' || fu.employee_id = hp.orig_system_reference
637: and hp.party_id = l_proj_mgr_id

Line 838: per_all_people_f papf

834: union
835: select fu.user_name, hp.party_name, hp.email_address
836: from fnd_user fu,
837: hz_parties hp,
838: per_all_people_f papf
839: where
840: --'PER:' || fu.employee_id = hp.orig_system_reference
841: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
842: AND 'PER:' = Substr(hp.orig_system_reference,1,4)