APPS.AS_SALES_ORG_MANAGER_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 682: From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel

678: decode(force.category,'EMPLOYEE',force.source_id,null),
679: null,
680: null,
681: decode(force.category,'PARTY',force.source_id,null)
682: From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel
683: ,JTF_RS_ROLES_B roleb, FND_User fnd_user
684: Where force.user_id = fnd_user.user_id
685: and fnd_user.user_id = p_user_id
686: and force.category in ('EMPLOYEE','PARTY')

Line 1293: FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role

1289: -- change to use jtf_rs_group_members
1290: CURSOR l_employee_role_cursor(c_salesforce_id NUMBER,
1291: c_sales_group_id NUMBER) IS
1292: SELECT 'Y'
1293: FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role
1294: WHERE rrel.role_id = role.role_id
1295: and role.member_flag = 'Y'
1296: and rrel.role_resource_id = mem.group_member_id
1297: and mem.resource_id = c_salesforce_id

Line 1302: -- Change to use jtf_rs_group_members, jtf_rs_roles_b and jtf_rs_role_relations

1298: and group_id IN
1299: (SELECT parent_group_id
1300: FROM jtf_rs_groups_denorm
1301: WHERE group_id = c_sales_group_id);
1302: -- Change to use jtf_rs_group_members, jtf_rs_roles_b and jtf_rs_role_relations
1303: CURSOR l_manager_role_cursor(c_salesforce_id NUMBER,
1304: c_sales_group_id NUMBER) IS
1305: SELECT 'Y'
1306: FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role

Line 1306: FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role

1302: -- Change to use jtf_rs_group_members, jtf_rs_roles_b and jtf_rs_role_relations
1303: CURSOR l_manager_role_cursor(c_salesforce_id NUMBER,
1304: c_sales_group_id NUMBER) IS
1305: SELECT 'Y'
1306: FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role
1307: WHERE rrel.role_id = role.role_id
1308: and role.manager_flag = 'Y'
1309: and rrel.role_resource_id = mem.group_member_id
1310: and mem.resource_id = c_salesforce_id

Line 1318: FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role

1314: WHERE group_id = c_sales_group_id);
1315: CURSOR l_admin_role_cursor(c_salesforce_id NUMBER,
1316: c_sales_group_id NUMBER) IS
1317: SELECT 'Y'
1318: FROM jtf_rs_group_members mem, jtf_rs_role_relations rrel, jtf_rs_roles_b role
1319: WHERE rrel.role_id = role.role_id
1320: and role.admin_flag = 'Y'
1321: and rrel.role_resource_id = mem.group_member_id
1322: and mem.resource_id = c_salesforce_id