APPS.AS_JTF_RS_GROUP_MEM_TRG dependencies on AS_SALES_LEADS

Line 172: from AS_SALES_LEADS sl, AS_STATUSES_B st

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:

Line 178: update AS_SALES_LEADS sl

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

Line 209: update AS_SALES_LEADS sl

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: