DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on JTF_RS_GROUP_USAGES

Line 1244: jtf_rs_group_usages rgu

1240: AND jtb.resource_id IN --select groups that user is member of
1241: (SELECT mem.group_id
1242: FROM
1243: jtf_rs_group_members mem,
1244: jtf_rs_group_usages rgu
1245: WHERE mem.resource_id = b_ResourceID
1246: AND nvl(mem.delete_flag, 'N') <> 'Y'
1247: AND rgu.group_id = mem.group_id
1248: AND rgu.usage = 'CALENDAR_ITEMS')

Line 1941: , jtf_rs_group_usages rgu

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)
1945: AND fgs.start_date < SYSDATE