DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on FND_OBJECTS

Line 80: , fnd_objects fos

76: , fgs.instance_pk1_value ResourceID
77: , jrt.resource_name ResourceName
78: FROM fnd_grants fgs
79: , fnd_menus fmu
80: , fnd_objects fos
81: , jtf_rs_resource_extns_tl jrt
82: WHERE fgs.object_id = fos.object_id -- grants joint to object
83: AND fgs.menu_id = fmu.menu_id -- grants joint to menus
84: AND fos.obj_name = 'JTF_TASK_RESOURCE'

Line 106: , fnd_objects fos

102: , fgs.instance_pk1_value ResourceID
103: , jrt.group_name ResourceName
104: FROM fnd_grants fgs
105: , fnd_menus fmu
106: , fnd_objects fos
107: , jtf_rs_groups_tl jrt
108: WHERE fgs.object_id = fos.object_id -- grants joint to object
109: AND fgs.menu_id = fmu.menu_id -- grants joint to menus
110: AND fmu.MENU_NAME in ('JTF_CAL_ADMIN_ACCESS','JTF_CAL_FULL_ACCESS')

Line 1777: , fnd_objects fos

1773: ) IS
1774: SELECT fmu.menu_name
1775: FROM fnd_grants fgs
1776: , fnd_menus fmu
1777: , fnd_objects fos
1778: WHERE fgs.object_id = fos.object_id
1779: AND fgs.menu_id = fmu.menu_id
1780: AND fos.obj_name = 'CAC_CAL_RESOURCES'
1781: AND fgs.grantee_key = FND_GLOBAL.USER_NAME

Line 1940: , fnd_objects fos

1936: , 'RS_EMPLOYEE'
1937: , TO_NUMBER(fgs.instance_pk1_value)
1938: ) Prefix*/
1939: FROM fnd_grants fgs
1940: , fnd_objects fos
1941: , jtf_rs_group_usages rgu
1942: WHERE fgs.object_id = fos.object_id -- grants joint to object
1943: AND fos.obj_name = 'JTF_TASK_RESOURCE'
1944: AND fgs.grantee_key = TO_CHAR(b_ResourceID)