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 102: FROM fnd_user

98: BEGIN
99: IF p_source_type='USER' THEN
100: SELECT employee_id, person_party_id -- Bug 4527617. Replaced customer_id with person_party_id.
101: INTO l_emp_id, l_cust_id
102: FROM fnd_user
103: WHERE user_id=p_source_id;
104:
105: IF l_emp_id IS NOT NULL AND l_emp_id > 0 THEN
106: OPEN get_role_for_employee(l_emp_id);

Line 377: from fnd_user users,

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

Line 428: from fnd_user users,

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

Line 448: from fnd_user users,

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