APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on JTF_RS_GROUP_MEMBERS

Line 959: from jtf_rs_group_members gm, jtf_rs_salesreps s

955: where resource_id = p_role_resource_id
956: AND p_role_resource_type = 'RS_INDIVIDUAL'
957: UNION ALL
958: select salesrep_id, org_id
959: from jtf_rs_group_members gm, jtf_rs_salesreps s
960: where gm.group_member_id = p_role_resource_id
961: and gm.resource_id = s.resource_id
962: and delete_flag = 'N'
963: AND p_role_resource_type = 'RS_GROUP_MEMBER'

Line 1438: from jtf_rs_group_members gm, jtf_rs_salesreps s

1434: where resource_id = l_role_resource_id
1435: AND l_role_resource_type = 'RS_INDIVIDUAL'
1436: UNION ALL
1437: select salesrep_id, org_id
1438: from jtf_rs_group_members gm, jtf_rs_salesreps s
1439: where gm.group_member_id = l_role_resource_id
1440: and gm.resource_id = s.resource_id
1441: and delete_flag = 'N'
1442: AND l_role_resource_type = 'RS_GROUP_MEMBER'

Line 1844: from jtf_rs_group_members gm, jtf_rs_salesreps s

1840: where resource_id = l_role_resource_id
1841: AND l_role_resource_type = 'RS_INDIVIDUAL'
1842: UNION ALL
1843: select salesrep_id, org_id
1844: from jtf_rs_group_members gm, jtf_rs_salesreps s
1845: where gm.group_member_id = l_role_resource_id
1846: and gm.resource_id = s.resource_id
1847: and delete_flag = 'N'
1848: AND l_role_resource_type = 'RS_GROUP_MEMBER'

Line 2187: from jtf_rs_group_members gm, jtf_rs_salesreps s

2183: where resource_id = l_role_resource_id
2184: AND l_role_resource_type = 'RS_INDIVIDUAL'
2185: UNION ALL
2186: select salesrep_id, org_id
2187: from jtf_rs_group_members gm, jtf_rs_salesreps s
2188: where gm.group_member_id = l_role_resource_id
2189: and gm.resource_id = s.resource_id
2190: and delete_flag = 'N'
2191: AND l_role_resource_type = 'RS_GROUP_MEMBER'