APPS.CSM_USER_EVENT_PKG dependencies on HZ_LOCATIONS

Line 497: hz_locations hzl

493: hz_cust_acct_sites_all cas,
494: csp_rs_cust_relations rcr,
495: jtf_rs_resource_extns jtrs,
496: hz_party_sites hps,
497: hz_locations hzl
498: WHERE csu.site_use_id = pla.site_use_id
499: AND csu.site_use_code = 'SHIP_TO'
500: AND csu.cust_acct_site_id = cas.cust_acct_site_id
501: AND csu.status = 'A'

Line 889: DELETE FROM CSM_HZ_LOCATIONS_ACC WHERE user_id = p_user_id;--Bug 5213097

885: DELETE FROM CSM_FND_LOBS_ACC WHERE user_id = p_user_id;--Bug 4938130
886: DELETE FROM CSM_HZ_CUST_ACCOUNTS_ACC WHERE user_id = p_user_id;--Bug 5213097
887: DELETE FROM CSM_SR_TYPE_MAPPING_ACC WHERE user_id = p_user_id;--Bug 5213097
888: DELETE FROM CSM_CSI_ITEM_ATTR_ACC WHERE user_id = p_user_id;--Bug 5213097
889: DELETE FROM CSM_HZ_LOCATIONS_ACC WHERE user_id = p_user_id;--Bug 5213097
890:
891: DELETE FROM CSM_HZ_CONTACT_POINTS_ACC WHERE user_id = p_user_id;
892: DELETE FROM CSM_COUNTER_PROP_VALUES_ACC WHERE user_id = p_user_id;
893: DELETE FROM CSM_COUNTER_PROPERTIES_ACC WHERE user_id = p_user_id;