APPS.AS_JTF_RS_GROUP_MEM_TRG dependencies on AS_LEADS_ALL

Line 93: from AS_LEADS_ALL ld, AS_STATUSES_B st

89: and nvl(acc2.address_id,-99) = nvl(acc.address_id,-99)
90: and nvl(acc2.org_id,-99) = nvl(acc.org_id,-99) )
91: and exists
92: ( select 1
93: from AS_LEADS_ALL ld, AS_STATUSES_B st
94: where acc.lead_id = ld.lead_id
95: and ld.status = st.status_code
96: and st.opp_open_status_flag = 'Y' );
97:

Line 105: from AS_LEADS_ALL ld, AS_STATUSES_B st

101: where sc.salesforce_id = x_new_resource_id
102: and sc.salesgroup_id = x_old_group_id
103: and exists
104: ( select 1
105: from AS_LEADS_ALL ld, AS_STATUSES_B st
106: where ld.status = st.status_code
107: and st.opp_open_status_flag = 'Y'
108: and sc.lead_id = ld.lead_id );
109:

Line 110: update AS_LEADS_ALL ld

106: where ld.status = st.status_code
107: and st.opp_open_status_flag = 'Y'
108: and sc.lead_id = ld.lead_id );
109:
110: update AS_LEADS_ALL ld
111: set object_version_number = nvl(object_version_number,0) + 1, ld.owner_sales_group_id = x_new_group_id
112: where ld.owner_salesforce_id = x_new_resource_id
113: and ld.owner_sales_group_id = x_old_group_id
114: and exists

Line 144: update AS_LEADS_ALL ld

140: set object_version_number = nvl(object_version_number,0) + 1, sc.salesgroup_id = x_new_group_id
141: where sc.salesforce_id = x_new_resource_id
142: and sc.salesgroup_id = x_old_group_id;
143:
144: update AS_LEADS_ALL ld
145: set object_version_number = nvl(object_version_number,0) + 1, ld.owner_sales_group_id = x_new_group_id
146: where ld.owner_salesforce_id = x_new_resource_id
147: and ld.owner_sales_group_id = x_old_group_id;
148: