APPS.PA_SECURITY_PVT dependencies on WF_ROLES

Line 79: wf_roles wfr

75:
76: cursor get_role_for_employee(c_emp_id NUMBER) is
77: select wfr.name, per.party_id
78: from per_all_people_f per,
79: wf_roles wfr
80: where per.person_id = c_emp_id
81: and per.party_id = wfr.orig_system_id /* Added outer join for bug 3417803 */
82: and wfr.orig_system = 'HZ_PARTY' /* Added outer join for bug 3417803 */
83: and rownum = 1;

Line 87: from wf_roles

83: and rownum = 1;
84:
85: cursor get_role_for_customer(c_cust_id NUMBER) is
86: select name
87: from wf_roles
88: where orig_system_id = c_cust_id
89: and orig_system = 'HZ_PARTY'
90: and rownum = 1;
91:

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

126: CLOSE get_role_for_customer;
127: l_cust_id := p_source_id;
128: END IF;
129:
130: -- Invoke TCA API to create WF_ROLES if it does not exists
131: /* Bug 3417803 - Modified condition l_grantee_key = '' to l_grantee_key is null */
132: IF (l_grantee_key is null OR l_grantee_key = '')
133: AND p_HZ_WF_Synch = 'Y' THEN
134: /* Added get_party_id code and if condition for bug 3484332 */

Line 2280: -- wf_roles wfr

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

Line 2290: wf_roles wfr

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
2293: and ppp.resource_source_id = per.person_id
2294: and per.party_id = wfr.orig_system_id

Line 2335: FROM wf_roles wfr

2331:
2332: IF res.resource_type_id = 112 THEN
2333: SELECT wfr.name grantee_key
2334: INTO l_grantee_key
2335: FROM wf_roles wfr
2336: WHERE wfr.orig_system_id = res.resource_source_id
2337: AND wfr.orig_system = 'HZ_PARTY'
2338: AND rownum = 1;
2339: ELSIF res.resource_type_id = 101 THEN

Line 2343: wf_roles wfr

2339: ELSIF res.resource_type_id = 101 THEN
2340: SELECT wfr.name grantee_key
2341: INTO l_grantee_key
2342: FROM per_all_people_f per,
2343: wf_roles wfr
2344: WHERE res.resource_source_id = per.person_id
2345: AND per.party_id = wfr.orig_system_id
2346: AND wfr.orig_system = 'HZ_PARTY'
2347: AND rownum = 1;

Line 2527: wf_roles wfr

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

Line 2536: wf_roles wfr

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
2539: and ppp.resource_source_id = per.person_id
2540: and per.party_id = wfr.orig_system_id