[Home] [Help]
1351: cursor analystid(objid fnd_grants.object_id%TYPE,
1352: orgid per_all_assignments_f.organization_id%TYPE,
1353: roleid fnd_grants.menu_id%TYPE ) is
1354: SELECT distinct per.person_id
1355: FROM fnd_grants fg, wf_roles wfr, per_all_people_f per
1356: WHERE fg.object_id = objid
1357: AND fg.instance_pk1_value = TO_CHAR(orgid)
1358: AND fg.menu_id = roleid
1359: AND fg.instance_type = 'INSTANCE'
1425: pep.full_name
1426: INTO P_PrimaryContactId,P_PrimaryContactName
1427: FROM fnd_grants fg,
1428: per_all_people_f pep, -- Bug 4684198 - use table
1429: wf_roles wfr
1430: WHERE fg.object_id = v_objid
1431: AND fg.instance_pk1_value = TO_CHAR(v_orgid)
1432: AND fg.menu_id = v_Primroleid
1433: AND fg.instance_type = 'INSTANCE'
1557: ,pep.full_name
1558: INTO x_PrimaryContactId,x_PrimaryContactName
1559: FROM fnd_grants fg,
1560: per_all_people_f pep, -- Bug 4684198 - use table
1561: wf_roles wfr
1562: WHERE fg.object_id = P_objid
1563: AND fg.instance_pk1_value = to_char(P_orgid)
1564: AND fg.menu_id = P_Primroleid
1565: AND fg.instance_type = 'INSTANCE'
2945: l_primary_contact_id
2946: FROM fnd_grants fg,
2947: fnd_objects fob,
2948: per_all_people_f pep, -- Bug 4684198 - use base table not secure view
2949: wf_roles wfr
2950: /* Bug# 2499051 - Moved the function call to fetch to a local variable at the start of the procedure
2951: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */
2952: WHERE fg.object_id = fob.object_id
2953: AND fob.obj_name = 'ORGANIZATION'
3613: FROM pa_resources_denorm res,
3614: fnd_grants fg,
3615: fnd_objects fob,
3616: per_all_people_f per,
3617: wf_roles wfr,
3618: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
3619: from dual) res_auth_menu
3620: WHERE fob.obj_name = 'ORGANIZATION'
3621: and res.resource_id = l_resource_id