[Home] [Help]
1272: cursor analystid(objid fnd_grants.object_id%TYPE,
1273: orgid per_all_assignments_f.organization_id%TYPE,
1274: roleid fnd_grants.menu_id%TYPE ) is
1275: SELECT distinct per.person_id
1276: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1277: WHERE fg.object_id = objid
1278: AND fg.instance_pk1_value = TO_CHAR(orgid)
1279: AND fg.menu_id = roleid
1280: AND fg.instance_type = 'INSTANCE'
1346: pep.full_name
1347: INTO P_PrimaryContactId,P_PrimaryContactName
1348: FROM fnd_grants fg,
1349: per_all_people_f pep, -- Bug 4684198 - use table
1350: wf_roles wfr
1351: WHERE fg.object_id = v_objid
1352: AND fg.instance_pk1_value = TO_CHAR(v_orgid)
1353: AND fg.menu_id = v_Primroleid
1354: AND fg.instance_type = 'INSTANCE'
1478: ,pep.full_name
1479: INTO x_PrimaryContactId,x_PrimaryContactName
1480: FROM fnd_grants fg,
1481: per_all_people_f pep, -- Bug 4684198 - use table
1482: wf_roles wfr
1483: WHERE fg.object_id = P_objid
1484: AND fg.instance_pk1_value = to_char(P_orgid)
1485: AND fg.menu_id = P_Primroleid
1486: AND fg.instance_type = 'INSTANCE'
2828: l_primary_contact_id
2829: FROM fnd_grants fg,
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'
3351: FROM pa_resources_denorm res,
3352: fnd_grants fg,
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