APPS.PA_SECURITY_PVT dependencies on FND_USER

Line 31: FROM fnd_user

27: G_project_roles_ins_set_id := get_instance_set_id(G_project_roles_ins_set_name);
28:
29: SELECT employee_id, person_party_id -- Bug 4527617. Replaced customer_id with person_party_id.
30: INTO l_emp_id, l_cust_id
31: FROM fnd_user
32: WHERE user_id=G_user_id;
33:
34: IF l_emp_id IS NOT NULL AND l_emp_id > 0 THEN
35: G_source_type := 'PERSON';

Line 112: FROM fnd_user

108: BEGIN
109: IF p_source_type='USER' THEN
110: SELECT employee_id, person_party_id -- Bug 4527617. Replaced customer_id with person_party_id.
111: INTO l_emp_id, l_cust_id
112: FROM fnd_user
113: WHERE user_id=p_source_id;
114:
115: IF l_emp_id IS NOT NULL AND l_emp_id > 0 THEN
116: OPEN get_role_for_employee(l_emp_id);

Line 387: from fnd_user users,

383: p_object_key in number ) return varchar2 is
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)

Line 438: from fnd_user users,

434: p_object_key in number ) return varchar2 is
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,

Line 458: from fnd_user users,

454: and ROWNUM=1;
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

Line 2721: from fnd_user_resp_groups_all a,

2717: --Get all the responsibilities for the user
2718: CURSOR user_resp_csr(p_user_id NUMBER) is
2719: select a.responsibility_id, c.application_id,
2720: b.responsibility_key, c.application_short_name
2721: from fnd_user_resp_groups_all a,
2722: fnd_responsibility_vl b,
2723: fnd_application c
2724: where a.user_id = p_user_id
2725: and sysdate between NVL(a.start_date,sysdate) and NVL(a.end_date,sysdate)