APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1529: jtf_rs_role_relations rel

1525: is
1526: select rel.role_relate_id,
1527: mem.group_id
1528: from jtf_rs_group_members mem,
1529: jtf_rs_role_relations rel
1530: where mem.group_id = l_no
1531: and nvl(mem.delete_flag , 'N') <> 'Y'
1532: and mem.group_member_id = rel.role_resource_id
1533: and rel.role_resource_type = 'RS_GROUP_MEMBER'

Line 1543: jtf_rs_role_relations rel,

1539: is
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

Line 3550: jtf_rs_role_relations rel

3546: is
3547: select rel.role_relate_id,
3548: mem.group_id
3549: from jtf_rs_group_members mem,
3550: jtf_rs_role_relations rel
3551: where mem.group_id = l_no
3552: and nvl(mem.delete_flag , 'N') <> 'Y'
3553: and mem.group_member_id = rel.role_resource_id
3554: and rel.role_resource_type = 'RS_GROUP_MEMBER'

Line 3564: jtf_rs_role_relations rel,

3560: is
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