APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 3166: UPDATE HZ_CUST_SITE_USES_ALL

3162: p_prefix=>l_debug_prefix,
3163: p_msg_level=>fnd_log.level_procedure);
3164: END IF;
3165:
3166: UPDATE HZ_CUST_SITE_USES_ALL
3167: SET PRIMARY_FLAG = 'Y',
3168: last_update_date = hz_utility_v2pub.last_update_date,
3169: last_updated_by = hz_utility_v2pub.last_updated_by,
3170: last_update_login = hz_utility_v2pub.last_update_login,

Line 3276: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b

3272: once the acct sites sharing the p_party_site_id are made inactive
3273: even for multiple accounts sharing p_party_site_id */
3274: cursor c_prim is
3275: SELECT MIN(b.site_use_id) , site_use_code
3276: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b
3277: WHERE a.cust_account_id in (select cust_account_id
3278: from hz_cust_acct_sites_all cas
3279: where cas.party_site_id = p_party_site_id)
3280: AND a.cust_acct_site_id = b.cust_acct_site_id

Line 3298: UPDATE HZ_CUST_SITE_USES_ALL

3294: END IF;
3295:
3296: -- check whether record has been updated by another user. If not, lock it.
3297: BEGIN
3298: UPDATE HZ_CUST_SITE_USES_ALL
3299: SET STATUS = p_new_status,
3300: primary_flag = 'N', --Bug 3370874
3301: last_update_date = hz_utility_v2pub.last_update_date,
3302: last_updated_by = hz_utility_v2pub.last_updated_by,