DBA Data[Home] [Help]

APPS.JTF_CAL_PVT dependencies on FND_MENUS

Line 38: , fnd_menus fmu

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
42: AND fgs.menu_id = fmu.menu_id -- grants joint to menus

Line 63: , fnd_menus fmu

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
67: AND fgs.menu_id = fmu.menu_id -- grants joint to menus