APPS.PA_SECURITY_PVT dependencies on PER_ALL_PEOPLE_F

Line 88: from per_all_people_f per,

84: /* Bug 3484332 - Reverted the outer join fix for performance */
85:
86: cursor get_role_for_employee(c_emp_id NUMBER) is
87: select /*+ leading(PER) index(PER PER_PEOPLE_F_PK) */ wfr.name, per.party_id
88: from per_all_people_f per,
89: wf_roles wfr
90: where per.person_id = c_emp_id
91: and per.party_id = wfr.orig_system_id /* Added outer join for bug 3417803 */
92: and wfr.orig_system = 'HZ_PARTY' /* Added outer join for bug 3417803 */

Line 105: FROM per_all_people_f per

101:
102: /* Added for bug 3484332 */
103: CURSOR get_party_id(c_emp_id NUMBER) IS
104: SELECT per.party_id
105: FROM per_all_people_f per
106: WHERE per.person_id = c_emp_id;
107:
108: BEGIN
109: IF p_source_type='USER' THEN

Line 2300: per_all_people_f per,

2296: /*
2297: UNION ALL
2298: select distinct ppp.resource_type_id,ppp.resource_source_id, wfr.name grantee_key
2299: from pa_project_parties ppp,
2300: per_all_people_f per,
2301: wf_roles wfr
2302: where ppp.project_role_id = p_project_role_id
2303: and ppp.resource_type_id = 101
2304: and ppp.resource_source_id = per.person_id

Line 2353: FROM per_all_people_f per,

2349: AND rownum = 1;
2350: ELSIF res.resource_type_id = 101 THEN
2351: SELECT wfr.name grantee_key
2352: INTO l_grantee_key
2353: FROM per_all_people_f per,
2354: wf_roles wfr
2355: WHERE res.resource_source_id = per.person_id
2356: AND per.party_id = wfr.orig_system_id
2357: AND wfr.orig_system = 'HZ_PARTY'

Line 2546: per_all_people_f per,

2542: and wfr.orig_system = 'HZ_PARTY'
2543: UNION ALL
2544: select distinct ppp.resource_type_id,ppp.resource_source_id, wfr.name grantee_key
2545: from pa_project_parties ppp,
2546: per_all_people_f per,
2547: wf_roles wfr
2548: where ppp.project_role_id = p_project_role_id
2549: and ppp.resource_type_id = 101
2550: and ppp.resource_source_id = per.person_id