APPS.AS_SALES_ORG_MANAGER_PVT dependencies on AS_SALESFORCE_V

Line 178: 'as_sales_groups_v sales_group, AS_SALESFORCE_V force, as_sales_groups_v manage_group ';

174:
175: -- fix bug 1265779, remove PER_ASSIGNMENTS_F, PER_JOBS
176: -- l_where_cl := 'From per_jobs job, per_assignments_f assign, PER_PEOPLE_F people, ' ||
177: l_where_cl := 'From PER_PEOPLE_F people, ' ||
178: 'as_sales_groups_v sales_group, AS_SALESFORCE_V force, as_sales_groups_v manage_group ';
179:
180: If (p_sales_member_rec.user_id <> FND_API.G_MISS_NUM) Then
181: l_where_cl := l_where_cl || ', FND_USER fnd_user ' ||
182: 'where fnd_user.employee_id = force.employee_person_id and ' ||

Line 703: From AS_SALESFORCE_V force

699: -- force.sales_group_id,
700: force.partner_address_id,
701: force.partner_customer_id,
702: force.partner_contact_id
703: From AS_SALESFORCE_V force
704: Where salesforce_id = p_salesforce_id
705: and rownum = 1;
706:
707: Cursor C_GetAdminGroup(p_salesforce_id NUMBER, p_sales_group_id NUMBER) IS

Line 1233: FROM as_rep_managers_v rm, as_salesforce_v sf1, as_salesforce_v sf2

1229: ) RETURN NUMBER IS
1230:
1231: CURSOR l_manager_sales_rel_csr (c_manager_id NUMBER, c_sales_id NUMBER) IS
1232: SELECT rm.reports_to_flag reports_to_flag
1233: FROM as_rep_managers_v rm, as_salesforce_v sf1, as_salesforce_v sf2
1234: WHERE rm.manager_person_id = sf1.employee_person_id
1235: AND rm.person_id = sf2.employee_person_id
1236: AND sf1.salesforce_id = c_manager_id
1237: AND sf2.salesforce_id = c_sales_id;

Line 1241: FROM as_rep_managers_v rm, as_salesforce_v sf

1237: AND sf2.salesforce_id = c_sales_id;
1238:
1239: CURSOR l_sales_org_csr (c_manager_id NUMBER) IS
1240: SELECT rm.reports_to_flag reports_to_flag
1241: FROM as_rep_managers_v rm, as_salesforce_v sf
1242: WHERE rm.manager_person_id = sf.employee_person_id
1243: AND rm.person_id <> sf.employee_person_id
1244: AND sf.salesforce_id = c_manager_id;
1245: