APPS.AS_AUTOCREATE_OPP dependencies on JTF_RS_ROLE_RELATIONS

Line 46: From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel

42:
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')

Line 64: FROM jtf_rs_role_relations REL

60: WHERE resource_id = p_salesforce_id
61: AND delete_flag = 'N'
62: AND EXISTS
63: (SELECT 'X'
64: FROM jtf_rs_role_relations REL
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