[Home] [Help]
130:
131: /* Start of Changes for Bug 6056112 */
132: SELECT pa_resource_utils.get_resource_id(p_resource_id)
133: INTO l_pa_resource_id
134: FROM dual;
135:
136: IF (l_pa_resource_id <> -999) THEN
137: SELECT nvl(future_term_wf_flag,'N')
138: INTO l_future_term_wf_flag
575: l_effective_date DATE;
576:
577: cursor cur_exist(l_res_id in NUMBER, l_date IN date) is
578: select 'X'
579: from dual
580: where exists (select res.resource_id
581: from pa_resources_denorm res,
582: pa_all_organizations org
583: where org.pa_org_use_type = 'EXPENDITURES'
2818:
2819: /* Bug# 2499051 */
2820: select pa_security_pvt.get_menu_id(p_prim_role_name)
2821: into l_menu_id
2822: from dual;
2823: /* Bug# 2499051 */
2824:
2825: SELECT pep.full_name,
2826: pep.person_id
2830: fnd_objects fob,
2831: per_all_people_f pep, -- Bug 4684198 - use base table not secure view
2832: wf_roles wfr
2833: /* Bug# 2499051 - Moved the function call to fetch to a local variable at the start of the procedure
2834: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */
2835: WHERE fg.object_id = fob.object_id
2836: AND fob.obj_name = 'ORGANIZATION'
2837: AND fg.instance_pk1_value = to_char(p_org_id)
2838: /* AND fg.menu_id = temp.menu_id -- Bug# 2499051 - Using local variable */
3353: fnd_objects fob,
3354: per_all_people_f per,
3355: wf_roles wfr,
3356: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
3357: from dual) res_auth_menu
3358: WHERE fob.obj_name = 'ORGANIZATION'
3359: and res.resource_id = l_resource_id
3360: and sysdate < res.resource_effective_end_date
3361: and fg.instance_pk1_value = to_char(res.resource_organization_id)
4427:
4428: BEGIN
4429: SELECT 'Y'
4430: INTO l_in_use
4431: FROM DUAL
4432: WHERE EXISTS (SELECT 'Y'
4433: FROM pa_resource_list_members
4434: WHERE vendor_id = p_supplier_id
4435: UNION ALL