DBA Data[Home] [Help]

APPS.AS_JTF_RS_GROUP_MEM_TRG dependencies on AS_SALES_CREDITS

Line 99: update AS_SALES_CREDITS sc

95: and ld.status = st.status_code
96: and st.opp_open_status_flag = 'Y' );
97:
98: -- Update Open Opportunities
99: update AS_SALES_CREDITS sc
100: set object_version_number = nvl(object_version_number,0) + 1, sc.salesgroup_id = x_new_group_id
101: where sc.salesforce_id = x_new_resource_id
102: and sc.salesgroup_id = x_old_group_id
103: and exists

Line 139: update AS_SALES_CREDITS sc

135: and acc2.sales_lead_id is null
136: and nvl(acc2.address_id,-99) = nvl(acc.address_id,-99)
137: and nvl(acc2.org_id,-99) = nvl(acc.org_id,-99) );
138:
139: update AS_SALES_CREDITS sc
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: