APPS.PA_SECURITY_PVT dependencies on PA_PROJECT_PARTIES

Line 362: -----in pa_project_parties

358:
359:
360: -----The following code is commented out because of instance sets and
361: -----resource roles like project authority and resource authority are not
362: -----in pa_project_parties
363: -----there is no perfect way to check if role based security is enforced or not
364:
365: /*---This API check if role based security is enforced or not
366: ----function check_sec_by_role

Line 378: pa_project_parties ppp,

374:
375: cursor c_role_sec_enabled is
376: select 'Y'
377: from fnd_user users,
378: pa_project_parties ppp,
379: pa_project_role_types roletypes
380: where decode (p_source_type, 'PERSON', users.employee_id,
381: 'HZ_PARTY', users.customer_id)
382: = ppp.resource_source_id

Line 429: pa_project_parties ppp,

425:
426: cursor c_unsecured_role is
427: select 'Y'
428: from fnd_user users,
429: pa_project_parties ppp,
430: --pa_project_role_types roletypes --bug 4004821
431: pa_project_role_types_b roletypes
432: where decode (p_source_type, 'PERSON', users.employee_id,
433: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.

Line 449: pa_project_parties ppp

445:
446: cursor c_any_role is
447: select 'Y'
448: from fnd_user users,
449: pa_project_parties ppp
450: where decode (p_source_type, 'PERSON', users.employee_id,
451: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
452: = ppp.resource_source_id
453: and ppp.resource_type_id= decode(p_source_type,'PERSON',101,

Line 462: ------or project authority. The assignments of these roles are not in pa_project_parties.

458: and ppp.object_type=p_object_name
459: and ROWNUM=1;
460:
461: ------There might be an issue for pre-seeded resource roles,like resource authority
462: ------or project authority. The assignments of these roles are not in pa_project_parties.
463: ---- check_sec_by_resp will always return true for these assignments.
464:
465: /* select 'Y'
466: from dual

Line 2279: from pa_project_parties ppp

2275:
2276: cursor get_resources_on_role is
2277: select distinct ppp.resource_type_id,ppp.resource_source_id
2278: -- , wfr.name grantee_key
2279: from pa_project_parties ppp
2280: -- wf_roles wfr
2281: where ppp.project_role_id = p_project_role_id;
2282: -- and ppp.resource_type_id = 112
2283: -- and ppp.resource_source_id = wfr.orig_system_id

Line 2288: from pa_project_parties ppp,

2284: -- and wfr.orig_system = 'HZ_PARTY'
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

Line 2526: from pa_project_parties ppp,

2522: ) is
2523:
2524: cursor get_resources_on_role is
2525: select distinct ppp.resource_type_id,ppp.resource_source_id, wfr.name grantee_key
2526: from pa_project_parties ppp,
2527: wf_roles wfr
2528: where ppp.project_role_id = p_project_role_id
2529: and ppp.resource_type_id = 112
2530: and ppp.resource_source_id = wfr.orig_system_id

Line 2534: from pa_project_parties ppp,

2530: and ppp.resource_source_id = wfr.orig_system_id
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