APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PER_ALL_PEOPLE_F

Line 356: per_all_people_f papf

352: CURSOR get_full_name_csr (l_person_id number)
353: IS
354: select papf.full_name
355: from
356: per_all_people_f papf
357: WHERE
358: papf.person_id = l_person_id;
359:
360:

Line 365: per_all_people_f papf, fnd_user fu

361: CURSOR get_user_name_csr (l_usr_id number)
362: IS
363: SELECT fu.user_name
364: from
365: per_all_people_f papf, fnd_user fu
366: WHERE
367: fu.user_id = l_usr_id
368: and
369: fu.employee_id = papf.person_id;

Line 374: from per_all_people_f papf,

370:
371:
372: CURSOR c_submitter_list IS
373: 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.
374: from per_all_people_f papf,
375: fnd_user usr
376: WHERE
377: papf.person_id = usr.employee_id
378: and trunc(sysdate)

Line 387: from per_all_people_f papf,

383:
384: CURSOR c_reporter_list IS
385: select UNIQUE usr.user_id, usr.person_party_id, -- Bug 4527617. Replaced customer_id with person_party_id.
386: usr.user_name,papf.email_address,papf.full_name person_name
387: from per_all_people_f papf,
388: fnd_user usr,
389: pa_project_parties ppp
390: WHERE
391: papf.person_id = usr.employee_id

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

843: l_version_id NUMBER;
844: l_reported_by_id NUMBER;
845: l_approver_id NUMBER;
846: l_approver_source_type NUMBER;
847: l_approver_name per_all_people_f.full_name%type; --Added for bug 4165764.
848:
849: l_user_name VARCHAR2(250);
850: l_role_users_table WF_DIRECTORY.UserTable; /*bug 5716959*/
851: l_count NUMBER := 1; /*bug 5716959*/

Line 865: fnd_user fu,per_all_people_f papf

861: fu.user_name,
862: papf.email_address,
863: papf.full_name person_name
864: from
865: fnd_user fu,per_all_people_f papf
866: where
867: fu.employee_id = l_approver_id
868: and papf.person_id = fu.employee_id
869: and trunc(sysdate)

Line 882: fnd_user fu,per_all_people_f papf

878: fu.user_name,
879: papf.email_address,
880: papf.full_name person_name
881: from
882: fnd_user fu,per_all_people_f papf
883: where
884: fu.person_party_id = l_approver_id -- Bug 4527617. Replaced customer_id with person_party_id.
885: and papf.person_id = fu.employee_id
886: and trunc(sysdate)

Line 908: FROM per_assignments_f p1, per_all_people_f p2

904: CURSOR l_approver_csr is
905: SELECT DISTINCT
906: fu.user_name,
907: p1.supervisor_id person_id, p2.full_name person_name, p2.email_address
908: FROM per_assignments_f p1, per_all_people_f p2
909: , fnd_user fu
910: WHERE p1.person_id = l_reported_by_id
911: and p1.supervisor_id = p2.person_id
912: AND p1.assignment_type in ('E', 'C') -- Added for bug 2911451

Line 1183: per_all_people_f papf,

1179: IS
1180: SELECT
1181: 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.
1182: FROM pa_project_lists_v pplv,
1183: per_all_people_f papf,
1184: fnd_user usr
1185: WHERE pplv.project_id = l_project_id
1186: and papf.person_id = usr.employee_id
1187: and trunc(sysdate)