DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on FND_GRANTS

Line 866: FROM fnd_grants fgs,

862: CURSOR c_group_calendar (b_resource_id IN VARCHAR2)
863: IS
864: SELECT DISTINCT fgs.instance_pk1_value resource_id,
865: fgs.instance_pk2_value resource_type
866: FROM fnd_grants fgs,
867: fnd_menus fmu,
868: fnd_objects fos,
869: jtf_rs_group_usages jru,
870: jtf_rs_groups_tl jrt

Line 1692: FROM fnd_menus fmu, fnd_objects fos, fnd_grants fgs

1688: -- 3) JTF_CAL_READ_ACCESS
1689: CURSOR c_access (b_group_id VARCHAR2, b_resource_id VARCHAR2)
1690: IS
1691: SELECT DISTINCT fmu.menu_name
1692: FROM fnd_menus fmu, fnd_objects fos, fnd_grants fgs
1693: WHERE fmu.menu_id = fgs.menu_id -- grants joint to menus
1694: AND fos.obj_name = 'JTF_TASK_RESOURCE'
1695: AND fos.object_id = fgs.object_id -- grants joint to object
1696: AND fgs.grantee_key = b_resource_id

Line 1794: FROM fnd_grants fg

1790: UNION ALL
1791: SELECT g.group_id resource_id
1792: , 'RS_GROUP' resource_type_code
1793: , 'Y' group_calendar_flag
1794: FROM fnd_grants fg
1795: , jtf_rs_groups_b g
1796: WHERE fg.grantee_key = to_char(p_resource_id)
1797: AND fg.grantee_type = 'USER'
1798: AND fg.instance_pk2_value = 'RS_GROUP'