APPS.PA_SECURITY_PVT dependencies on WF_ROLES

Line 89: wf_roles wfr

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 */
93: and rownum = 1;

Line 97: from wf_roles

93: and rownum = 1;
94:
95: cursor get_role_for_customer(c_cust_id NUMBER) is
96: select name
97: from wf_roles
98: where orig_system_id = c_cust_id
99: and orig_system = 'HZ_PARTY'
100: and rownum = 1;
101:

Line 140: -- Invoke TCA API to create WF_ROLES if it does not exists

136: CLOSE get_role_for_customer;
137: l_cust_id := p_source_id;
138: END IF;
139:
140: -- Invoke TCA API to create WF_ROLES if it does not exists
141: /* Bug 3417803 - Modified condition l_grantee_key = '' to l_grantee_key is null */
142: IF (l_grantee_key is null OR l_grantee_key = '')
143: AND p_HZ_WF_Synch = 'Y' THEN
144: /* Added get_party_id code and if condition for bug 3484332 */

Line 2291: -- wf_roles wfr

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

Line 2301: wf_roles wfr

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
2305: and per.party_id = wfr.orig_system_id

Line 2346: FROM wf_roles wfr

2342:
2343: IF res.resource_type_id = 112 THEN
2344: SELECT wfr.name grantee_key
2345: INTO l_grantee_key
2346: FROM wf_roles wfr
2347: WHERE wfr.orig_system_id = res.resource_source_id
2348: AND wfr.orig_system = 'HZ_PARTY'
2349: AND rownum = 1;
2350: ELSIF res.resource_type_id = 101 THEN

Line 2354: wf_roles wfr

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'
2358: AND rownum = 1;

Line 2538: wf_roles wfr

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

Line 2547: wf_roles wfr

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
2551: and per.party_id = wfr.orig_system_id