APPS.PA_SECURITY_PVT dependencies on PER_ALL_PEOPLE_F

Line 78: from per_all_people_f per,

74: /* Bug 3484332 - Reverted the outer join fix for performance */
75:
76: cursor get_role_for_employee(c_emp_id NUMBER) is
77: select wfr.name, per.party_id
78: from per_all_people_f per,
79: wf_roles wfr
80: where per.person_id = c_emp_id
81: and per.party_id = wfr.orig_system_id /* Added outer join for bug 3417803 */
82: and wfr.orig_system = 'HZ_PARTY' /* Added outer join for bug 3417803 */

Line 95: FROM per_all_people_f per

91:
92: /* Added for bug 3484332 */
93: CURSOR get_party_id(c_emp_id NUMBER) IS
94: SELECT per.party_id
95: FROM per_all_people_f per
96: WHERE per.person_id = c_emp_id;
97:
98: BEGIN
99: IF p_source_type='USER' THEN

Line 2289: per_all_people_f per,

2285: /*
2286: UNION ALL
2287: select distinct ppp.resource_type_id,ppp.resource_source_id, wfr.name grantee_key
2288: from pa_project_parties ppp,
2289: per_all_people_f per,
2290: wf_roles wfr
2291: where ppp.project_role_id = p_project_role_id
2292: and ppp.resource_type_id = 101
2293: and ppp.resource_source_id = per.person_id

Line 2342: FROM per_all_people_f per,

2338: AND rownum = 1;
2339: ELSIF res.resource_type_id = 101 THEN
2340: SELECT wfr.name grantee_key
2341: INTO l_grantee_key
2342: FROM per_all_people_f per,
2343: wf_roles wfr
2344: WHERE res.resource_source_id = per.person_id
2345: AND per.party_id = wfr.orig_system_id
2346: AND wfr.orig_system = 'HZ_PARTY'

Line 2535: per_all_people_f per,

2531: and wfr.orig_system = 'HZ_PARTY'
2532: UNION ALL
2533: select distinct ppp.resource_type_id,ppp.resource_source_id, wfr.name grantee_key
2534: from pa_project_parties ppp,
2535: per_all_people_f per,
2536: wf_roles wfr
2537: where ppp.project_role_id = p_project_role_id
2538: and ppp.resource_type_id = 101
2539: and ppp.resource_source_id = per.person_id