APPS.AS_OPP_SALES_CREDIT_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 220: FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c, JTF_RS_ROLE_RELATIONS d , JTF_RS_ROLES_B e

216: -- AND a.resource_id = c.resource_id
217: -- AND a.resource_id = c_SALESFORCE_ID;
218: -- fix the bug 2549218
219: SELECT to_char(max(c.group_id))
220: FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c, JTF_RS_ROLE_RELATIONS d , JTF_RS_ROLES_B e
221: WHERE a.user_id = b.user_id
222: AND a.resource_id = c.resource_id
223: AND e.ROLE_TYPE_CODE in ('SALES','TELESALES','FIELDSALES','PRM')
224: AND c.GROUP_MEMBER_ID = d.ROLE_RESOURCE_ID

Line 3100: jtf_rs_role_relations rrel,

3096: CURSOR C_Salesforce_Person_Exists (X_Salesforce_Id NUMBER,
3097: X_Person_Id NUMBER ) IS
3098: SELECT 'X'
3099: FROM jtf_rs_resource_extns res,
3100: jtf_rs_role_relations rrel,
3101: jtf_rs_roles_b role
3102: WHERE sysdate between res.start_date_active and nvl(res.end_date_active,sysdate)
3103: AND sysdate between rrel.start_date_active and nvl(rrel.end_date_active,sysdate)
3104: AND res.resource_id = rrel.role_resource_id