APPS.AS_SALES_ORG_MANAGER_PVT dependencies on JTF_RS_GROUPS_DENORM

Line 1300: FROM jtf_rs_groups_denorm

1296: and rrel.role_resource_id = mem.group_member_id
1297: and mem.resource_id = c_salesforce_id
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

Line 1313: FROM jtf_rs_groups_denorm

1309: and rrel.role_resource_id = mem.group_member_id
1310: and mem.resource_id = c_salesforce_id
1311: and group_id IN
1312: (SELECT parent_group_id
1313: FROM jtf_rs_groups_denorm
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'

Line 1325: FROM jtf_rs_groups_denorm

1321: and rrel.role_resource_id = mem.group_member_id
1322: and mem.resource_id = c_salesforce_id
1323: and group_id IN
1324: (SELECT parent_group_id
1325: FROM jtf_rs_groups_denorm
1326: WHERE group_id = c_sales_group_id);
1327: l_member_role VARCHAR2(1);
1328: l_flag VARCHAR2(1);
1329: BEGIN