DBA Data[Home] [Help]

APPS.JTF_CAL_PVT dependencies on FND_GRANTS

Line 37: FROM fnd_grants fgs

33: ****************************************************************/
34: IS SELECT DISTINCT fmu.menu_name Privilege
35: , fgs.instance_pk1_value ResourceID
36: , jrt.resource_name ResourceName
37: FROM fnd_grants fgs
38: , fnd_menus fmu
39: , fnd_objects fos
40: , jtf_rs_resource_extns_tl jrt
41: WHERE fgs.object_id = fos.object_id -- grants joint to object

Line 62: FROM fnd_grants fgs

58: *****************************************************************************/
59: IS SELECT DISTINCT DECODE(fmu.menu_name,'JTF_CAL_ADMIN_ACCESS','JTF_CAL_FULL_ACCESS',FMU.MENU_NAME) Privilege
60: , fgs.instance_pk1_value ResourceID
61: , jrt.group_name ResourceName
62: FROM fnd_grants fgs
63: , fnd_menus fmu
64: , fnd_objects fos
65: , jtf_rs_groups_tl jrt
66: WHERE fgs.object_id = fos.object_id -- grants joint to object

Line 722: FROM fnd_grants fgs

718: ( b_ResourceID
719: , 'RS_EMPLOYEE'
720: , TO_NUMBER(fgs.instance_pk1_value)
721: ) Prefix
722: FROM fnd_grants fgs
723: , fnd_objects fos
724: , jtf_rs_group_usages rgu
725: WHERE fgs.object_id = fos.object_id -- grants joint to object
726: AND fos.obj_name = 'JTF_TASK_RESOURCE'