DBA Data[Home] [Help]

APPS.JTF_CAL_PVT dependencies on FND_OBJECTS

Line 39: , fnd_objects fos

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
43: AND fos.obj_name = 'JTF_TASK_RESOURCE'

Line 64: , fnd_objects fos

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
68: AND fmu.MENU_NAME in ('JTF_CAL_ADMIN_ACCESS','JTF_CAL_FULL_ACCESS')

Line 723: , fnd_objects fos

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'
727: AND fgs.grantee_key = TO_CHAR(b_ResourceID)