DBA Data[Home] [Help]

APPS.JTF_CAL_PVT dependencies on JTF_RS_GROUP_USAGES

Line 489: jtf_rs_group_usages rgu

485: AND jtb.resource_id IN --select groups that user is member of
486: (SELECT mem.group_id
487: FROM
488: jtf_rs_group_members mem,
489: jtf_rs_group_usages rgu
490: WHERE mem.resource_id = b_ResourceID
491: AND nvl(mem.delete_flag, 'N') <> 'Y'
492: AND rgu.group_id = mem.group_id
493: AND rgu.usage = 'CALENDAR_ITEMS')

Line 724: , jtf_rs_group_usages rgu

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