DBA Data[Home] [Help]

APPS.CAC_VIEW_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1243: jtf_rs_group_members mem,

1239: AND jtb.resource_type = 'RS_GROUP'
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