APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PER_ALL_PEOPLE_F

Line 364: per_all_people_f papf

360: CURSOR get_full_name_csr (l_person_id number)
361: IS
362: select papf.full_name
363: from
364: per_all_people_f papf
365: WHERE
366: papf.person_id = l_person_id;
367:
368:

Line 373: per_all_people_f papf, fnd_user fu

369: CURSOR get_user_name_csr (l_usr_id number)
370: IS
371: SELECT fu.user_name
372: from
373: per_all_people_f papf, fnd_user fu
374: WHERE
375: fu.user_id = l_usr_id
376: and
377: fu.employee_id = papf.person_id;

Line 382: from per_all_people_f papf,

378:
379:
380: CURSOR c_submitter_list IS
381: select UNIQUE usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
382: from per_all_people_f papf,
383: fnd_user usr
384: WHERE
385: papf.person_id = usr.employee_id
386: and trunc(sysdate)

Line 395: from per_all_people_f papf,

391:
392: CURSOR c_reporter_list IS
393: select UNIQUE usr.user_id, usr.person_party_id, -- Bug 4527617. Replaced customer_id with person_party_id.
394: usr.user_name,papf.email_address,papf.full_name person_name
395: from per_all_people_f papf,
396: fnd_user usr,
397: pa_project_parties ppp
398: WHERE
399: papf.person_id = usr.employee_id

Line 875: l_approver_name per_all_people_f.full_name%type; --Added for bug 4165764.

871: l_version_id NUMBER;
872: l_reported_by_id NUMBER;
873: l_approver_id NUMBER;
874: l_approver_source_type NUMBER;
875: l_approver_name per_all_people_f.full_name%type; --Added for bug 4165764.
876:
877: l_user_name VARCHAR2(250);
878: l_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
879: l_count NUMBER := 1; /*bug 5716959*/

Line 893: fnd_user fu,per_all_people_f papf

889: fu.user_name,
890: papf.email_address,
891: papf.full_name person_name
892: from
893: fnd_user fu,per_all_people_f papf
894: where
895: fu.employee_id = l_approver_id
896: and papf.person_id = fu.employee_id
897: and trunc(sysdate)

Line 910: fnd_user fu,per_all_people_f papf

906: fu.user_name,
907: papf.email_address,
908: papf.full_name person_name
909: from
910: fnd_user fu,per_all_people_f papf
911: where
912: fu.person_party_id = l_approver_id -- Bug 4527617. Replaced customer_id with person_party_id.
913: and papf.person_id = fu.employee_id
914: and trunc(sysdate)

Line 936: FROM per_assignments_f p1, per_all_people_f p2

932: CURSOR l_approver_csr is
933: SELECT DISTINCT
934: fu.user_name,
935: p1.supervisor_id person_id, p2.full_name person_name, p2.email_address
936: FROM per_assignments_f p1, per_all_people_f p2
937: , fnd_user fu
938: WHERE p1.person_id = l_reported_by_id
939: and p1.supervisor_id = p2.person_id
940: AND p1.assignment_type in ('E', 'C') -- Added for bug 2911451

Line 1233: per_all_people_f papf,

1229: IS
1230: SELECT
1231: usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
1232: FROM pa_project_lists_v pplv,
1233: per_all_people_f papf,
1234: fnd_user usr
1235: WHERE pplv.project_id = l_project_id
1236: and papf.person_id = usr.employee_id
1237: and trunc(sysdate)