APPS.ARP_CMERGE_ARCUS dependencies on HZ_PARTY_SITES

Line 4037: do_copy_contact_points ( 'HZ_PARTY_SITES',

4033: BEGIN
4034:
4035: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()+' );
4036:
4037: do_copy_contact_points ( 'HZ_PARTY_SITES',
4038: p_from_party_site_id,
4039: p_to_party_site_id,
4040: p_from_account_id );
4041:

Line 5392: FROM hz_party_sites

5388: and org_id = m_org_id; --SSUptake
5389:
5390: --Select merge-from's address
5391: SELECT location_id INTO l_location_id
5392: FROM hz_party_sites
5393: WHERE party_site_id = l_duplicate_party_site_id;
5394:
5395: --Select merge-to's party
5396: SELECT party_id INTO l_merge_to_party_id

Line 5418: FROM hz_party_sites

5414: WHERE cust_account_id = l_customer_id
5415: AND org_id = m_org_id --SSUptake
5416: AND party_site_id IN (
5417: SELECT party_site_id
5418: FROM hz_party_sites
5419: WHERE location_id = l_location_id
5420: AND party_id = l_merge_to_party_id )
5421: AND ROWNUM = 1;
5422:

Line 5434: FROM hz_party_sites

5430:
5431: BEGIN
5432:
5433: SELECT party_site_id INTO l_party_site_id
5434: FROM hz_party_sites
5435: WHERE party_id = l_merge_to_party_id
5436: AND location_id = l_location_id
5437: AND ROWNUM = 1;
5438:

Line 5561: FROM hz_party_sites ps

5557: --In case of there exist multiple party site on the address, we
5558: --pick up the one with mininum id (and same business purpose, if exists)
5559:
5560: SELECT MIN(party_site_id) INTO l_party_site_id
5561: FROM hz_party_sites ps
5562: WHERE party_id = l_merge_to_party_id
5563: AND location_id = l_location_id
5564: AND EXISTS ( --'same site usage'
5565: SELECT party_site_use_id

Line 5574: FROM hz_party_sites

5570: --No corresponding party site use. We need to create a new one.
5571: IF l_party_site_id IS NULL THEN
5572:
5573: SELECT MIN(party_site_id) INTO l_party_site_id
5574: FROM hz_party_sites
5575: WHERE party_id = l_merge_to_party_id
5576: AND location_id = l_location_id;
5577:
5578: l_create_party_site_use := 'Y';

Line 5855: FROM hz_party_sites

5851: WHERE cust_account_id = l_customer_id
5852: AND org_id = m_org_id --SSUptake
5853: AND party_site_id IN (
5854: SELECT party_site_id
5855: FROM hz_party_sites
5856: WHERE location_id = l_location_id
5857: AND party_id = l_merge_to_party_id )
5858: AND EXISTS ( --'same site usage'
5859: SELECT site_use_id

Line 5875: FROM hz_party_sites

5871: WHERE cust_account_id = l_customer_id
5872: and org_id = m_org_id --SSUptake
5873: AND party_site_id IN (
5874: SELECT party_site_id
5875: FROM hz_party_sites
5876: WHERE location_id = l_location_id
5877: AND party_id = l_merge_to_party_id );
5878:
5879: l_create_acct_site_use := 'Y';

Line 5902: FROM hz_party_sites ps

5898: --In case of there exist multiple party site on the address, we
5899: --pick up the one with mininum id (and same business purpose, if exists)
5900:
5901: SELECT MIN(party_site_id) INTO l_party_site_id
5902: FROM hz_party_sites ps
5903: WHERE party_id = l_merge_to_party_id
5904: AND location_id = l_location_id
5905: AND EXISTS ( --'same site usage'
5906: SELECT party_site_use_id

Line 5915: FROM hz_party_sites

5911: --No corresponding party site use. We need to create a new one.
5912: IF l_party_site_id IS NULL THEN
5913:
5914: SELECT MIN(party_site_id) INTO l_party_site_id
5915: FROM hz_party_sites
5916: WHERE party_id = l_merge_to_party_id
5917: AND location_id = l_location_id;
5918:
5919: l_create_party_site_use := 'Y';

Line 6866: FROM hz_party_sites

6862: WHERE site_use_id = l_customer_site_id;
6863: end if;
6864: --bug 3959776
6865: SELECT party_site_number INTO l_party_site_number
6866: FROM hz_party_sites
6867: WHERE party_site_id = ( SELECT party_site_id
6868: FROM hz_cust_acct_sites_all
6869: WHERE cust_acct_site_id = l_customer_address_id);
6870: UPDATE ra_customer_merges