DBA Data[Home] [Help]

APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 281: FROM JTF_RS_GROUP_MEMBERS mem,

277: WHERE lead_id = c_lead_id;
278:
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

Line 878: FROM JTF_RS_GROUP_MEMBERS mem,

874: WHERE resource_id = c_resource_id;
875:
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