DBA Data[Home] [Help]

APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on JTF_RS_GROUPS_B

Line 285: JTF_RS_GROUPS_B grp

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'
288: AND rrel.role_id = role.role_id
289: AND role.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')

Line 882: JTF_RS_GROUPS_B grp

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'
885: AND rrel.role_id = role.role_id
886: AND role.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')