APPS.PA_SECURITY_PVT dependencies on PA_PROJECT_PARTIES

Line 372: -----in pa_project_parties

368:
369:
370: -----The following code is commented out because of instance sets and
371: -----resource roles like project authority and resource authority are not
372: -----in pa_project_parties
373: -----there is no perfect way to check if role based security is enforced or not
374:
375: /*---This API check if role based security is enforced or not
376: ----function check_sec_by_role

Line 388: pa_project_parties ppp,

384:
385: cursor c_role_sec_enabled is
386: select 'Y'
387: from fnd_user users,
388: pa_project_parties ppp,
389: pa_project_role_types roletypes
390: where decode (p_source_type, 'PERSON', users.employee_id,
391: 'HZ_PARTY', users.customer_id)
392: = ppp.resource_source_id

Line 439: pa_project_parties ppp,

435:
436: cursor c_unsecured_role is
437: select 'Y'
438: from fnd_user users,
439: pa_project_parties ppp,
440: --pa_project_role_types roletypes --bug 4004821
441: pa_project_role_types_b roletypes
442: where decode (p_source_type, 'PERSON', users.employee_id,
443: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.

Line 459: pa_project_parties ppp

455:
456: cursor c_any_role is
457: select 'Y'
458: from fnd_user users,
459: pa_project_parties ppp
460: where decode (p_source_type, 'PERSON', users.employee_id,
461: 'HZ_PARTY', users.person_party_id) -- Bug 4527617. Replaced customer_id with person_party_id.
462: = ppp.resource_source_id
463: and ppp.resource_type_id= decode(p_source_type,'PERSON',101,

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

468: and ppp.object_type=p_object_name
469: and ROWNUM=1;
470:
471: ------There might be an issue for pre-seeded resource roles,like resource authority
472: ------or project authority. The assignments of these roles are not in pa_project_parties.
473: ---- check_sec_by_resp will always return true for these assignments.
474:
475: /* select 'Y'
476: from dual

Line 2290: from pa_project_parties ppp

2286:
2287: cursor get_resources_on_role is
2288: select distinct ppp.resource_type_id,ppp.resource_source_id
2289: -- , wfr.name grantee_key
2290: from pa_project_parties ppp
2291: -- wf_roles wfr
2292: where ppp.project_role_id = p_project_role_id;
2293: -- and ppp.resource_type_id = 112
2294: -- and ppp.resource_source_id = wfr.orig_system_id

Line 2299: from pa_project_parties ppp,

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

Line 2537: from pa_project_parties ppp,

2533: ) is
2534:
2535: cursor get_resources_on_role is
2536: select distinct ppp.resource_type_id,ppp.resource_source_id, wfr.name grantee_key
2537: from pa_project_parties ppp,
2538: wf_roles wfr
2539: where ppp.project_role_id = p_project_role_id
2540: and ppp.resource_type_id = 112
2541: and ppp.resource_source_id = wfr.orig_system_id

Line 2545: from pa_project_parties ppp,

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