168: and nvl(acc2.address_id,-99) = nvl(acc.address_id,-99)
169: and nvl(acc2.org_id,-99) = nvl(acc.org_id,-99) )
170: and exists
171: ( select 1
172: from AS_SALES_LEADS sl, AS_STATUSES_B st
173: where acc.sales_lead_id = sl.sales_lead_id
174: and sl.status_code = st.status_code
175: and st.opp_open_status_flag = 'Y' );
176:
174: and sl.status_code = st.status_code
175: and st.opp_open_status_flag = 'Y' );
176:
177: -- Update Open Sales Leads
178: update AS_SALES_LEADS sl
179: set sl.assign_sales_group_id = x_new_group_id
180: where sl.assign_to_salesforce_id = x_new_resource_id
181: and sl.assign_sales_group_id = x_old_group_id
182: and exists
205: and nvl(acc2.address_id,-99) = nvl(acc.address_id,-99)
206: and nvl(acc2.org_id,-99) = nvl(acc.org_id,-99) );
207:
208: -- Update Sales Leads
209: update AS_SALES_LEADS sl
210: set sl.assign_sales_group_id = x_new_group_id
211: where sl.assign_to_salesforce_id = x_new_resource_id
212: and sl.assign_sales_group_id = x_old_group_id;
213: