APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 3173: UPDATE HZ_CUST_SITE_USES_ALL

3169: p_prefix=>l_debug_prefix,
3170: p_msg_level=>fnd_log.level_procedure);
3171: END IF;
3172:
3173: UPDATE HZ_CUST_SITE_USES_ALL
3174: SET PRIMARY_FLAG = 'Y',
3175: last_update_date = hz_utility_v2pub.last_update_date,
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,

Line 3283: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b

3279: once the acct sites sharing the p_party_site_id are made inactive
3280: even for multiple accounts sharing p_party_site_id */
3281: cursor c_prim is
3282: SELECT MIN(b.site_use_id) , site_use_code
3283: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b
3284: WHERE a.cust_account_id in (select cust_account_id
3285: from hz_cust_acct_sites_all cas
3286: where cas.party_site_id = p_party_site_id)
3287: AND a.cust_acct_site_id = b.cust_acct_site_id

Line 3305: UPDATE HZ_CUST_SITE_USES_ALL

3301: END IF;
3302:
3303: -- check whether record has been updated by another user. If not, lock it.
3304: BEGIN
3305: UPDATE HZ_CUST_SITE_USES_ALL
3306: SET STATUS = p_new_status,
3307: primary_flag = 'N', --Bug 3370874
3308: last_update_date = hz_utility_v2pub.last_update_date,
3309: last_updated_by = hz_utility_v2pub.last_updated_by,