APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_ROLES_B

Line 1544: jtf_rs_roles_b rol

1540: select rel.role_relate_id,
1541: mem.group_id
1542: from jtf_rs_group_members mem,
1543: jtf_rs_role_relations rel,
1544: jtf_rs_roles_b rol
1545: where mem.group_id = l_group_id
1546: and nvl(mem.delete_flag , 'N') <> 'Y'
1547: and mem.group_member_id = rel.role_resource_id
1548: and rel.role_resource_type = 'RS_GROUP_MEMBER'

Line 3565: jtf_rs_roles_b rol

3561: select rel.role_relate_id,
3562: mem.group_id
3563: from jtf_rs_group_members mem,
3564: jtf_rs_role_relations rel,
3565: jtf_rs_roles_b rol
3566: where mem.group_id = l_group_id
3567: and nvl(mem.delete_flag , 'N') <> 'Y'
3568: and mem.group_member_id = rel.role_resource_id
3569: and rel.role_resource_type = 'RS_GROUP_MEMBER'