APPS.AS_AUTOCREATE_OPP dependencies on JTF_RS_ROLES_B

Line 47: ,JTF_RS_ROLES_B roleb, FND_User fnd_user

43:
44: Cursor C_GetIdentity_FndUser(p_user_id Number) IS
45: Select force.resource_id
46: From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel
47: ,JTF_RS_ROLES_B roleb, FND_User fnd_user
48: Where force.user_id = fnd_user.user_id
49: and fnd_user.user_id = p_user_id
50: and force.category in ('EMPLOYEE','PARTY')
51: and force.resource_id = rrel.role_resource_id

Line 69: AND role_id IN (SELECT role_id FROM jtf_rs_roles_b WHERE role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM')));

65: WHERE role_resource_type = 'RS_GROUP_MEMBER'
66: AND delete_flag = 'N'
67: AND sysdate between REL.start_date_active and nvl(REL.end_date_active,sysdate)
68: AND REL.role_resource_id = GRPMEM.group_member_id
69: AND role_id IN (SELECT role_id FROM jtf_rs_roles_b WHERE role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM')));
70:
71:
72:
73: l_sales_lead_id NUMBER;