DBA Data[Home] [Help]

APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 963: UPDATE hz_cust_acct_sites_all cas

959: object_version_number = nvl(object_version_number,1)+1
960: WHERE location_id = l_location_rec.location_id;
961:
962: -- Fix bug 4169728. Set address_text to null.
963: UPDATE hz_cust_acct_sites_all cas
964: SET cas.address_text = null
965: WHERE cas.address_text IS NOT NULL
966: AND EXISTS
967: ( SELECT 1