DBA Data[Home] [Help]

APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on JTF_RS_ROLES_B

Line 283: JTF_RS_ROLES_B role,

279: CURSOR c_get_group_id (c_resource_id NUMBER) IS
280: SELECT grp.group_id
281: FROM JTF_RS_GROUP_MEMBERS mem,
282: JTF_RS_ROLE_RELATIONS rrel,
283: JTF_RS_ROLES_B role,
284: JTF_RS_GROUP_USAGES u,
285: JTF_RS_GROUPS_B grp
286: WHERE mem.group_member_id = rrel.role_resource_id
287: AND rrel.role_resource_type = 'RS_GROUP_MEMBER'

Line 880: JTF_RS_ROLES_B role,

876: CURSOR c_get_group_id (c_resource_id NUMBER) IS
877: SELECT grp.group_id
878: FROM JTF_RS_GROUP_MEMBERS mem,
879: JTF_RS_ROLE_RELATIONS rrel,
880: JTF_RS_ROLES_B role,
881: JTF_RS_GROUP_USAGES u,
882: JTF_RS_GROUPS_B grp
883: WHERE mem.group_member_id = rrel.role_resource_id
884: AND rrel.role_resource_type = 'RS_GROUP_MEMBER'