APPS.ARP_CMERGE_ARCUS dependencies on HZ_PARTY_SITES

Line 3729: do_copy_contact_points ( 'HZ_PARTY_SITES',

3725: BEGIN
3726:
3727: arp_message.set_line( 'ARP_CMERGE_ARCUS.do_site_merge_cpoint()+' );
3728:
3729: do_copy_contact_points ( 'HZ_PARTY_SITES',
3730: p_from_party_site_id,
3731: p_to_party_site_id,
3732: p_from_account_id );
3733:

Line 5079: FROM hz_party_sites

5075: and org_id = m_org_id; --SSUptake
5076:
5077: --Select merge-from's address
5078: SELECT location_id INTO l_location_id
5079: FROM hz_party_sites
5080: WHERE party_site_id = l_duplicate_party_site_id;
5081:
5082: --Select merge-to's party
5083: SELECT party_id INTO l_merge_to_party_id

Line 5105: FROM hz_party_sites

5101: WHERE cust_account_id = l_customer_id
5102: AND org_id = m_org_id --SSUptake
5103: AND party_site_id IN (
5104: SELECT party_site_id
5105: FROM hz_party_sites
5106: WHERE location_id = l_location_id
5107: AND party_id = l_merge_to_party_id )
5108: AND ROWNUM = 1;
5109:

Line 5121: FROM hz_party_sites

5117:
5118: BEGIN
5119:
5120: SELECT party_site_id INTO l_party_site_id
5121: FROM hz_party_sites
5122: WHERE party_id = l_merge_to_party_id
5123: AND location_id = l_location_id
5124: AND ROWNUM = 1;
5125:

Line 5246: FROM hz_party_sites ps

5242: --In case of there exist multiple party site on the address, we
5243: --pick up the one with mininum id (and same business purpose, if exists)
5244:
5245: SELECT MIN(party_site_id) INTO l_party_site_id
5246: FROM hz_party_sites ps
5247: WHERE party_id = l_merge_to_party_id
5248: AND location_id = l_location_id
5249: AND EXISTS ( --'same site usage'
5250: SELECT party_site_use_id

Line 5259: FROM hz_party_sites

5255: --No corresponding party site use. We need to create a new one.
5256: IF l_party_site_id IS NULL THEN
5257:
5258: SELECT MIN(party_site_id) INTO l_party_site_id
5259: FROM hz_party_sites
5260: WHERE party_id = l_merge_to_party_id
5261: AND location_id = l_location_id;
5262:
5263: l_create_party_site_use := 'Y';

Line 5527: FROM hz_party_sites

5523: WHERE cust_account_id = l_customer_id
5524: AND org_id = m_org_id --SSUptake
5525: AND party_site_id IN (
5526: SELECT party_site_id
5527: FROM hz_party_sites
5528: WHERE location_id = l_location_id
5529: AND party_id = l_merge_to_party_id )
5530: AND EXISTS ( --'same site usage'
5531: SELECT site_use_id

Line 5547: FROM hz_party_sites

5543: WHERE cust_account_id = l_customer_id
5544: and org_id = m_org_id --SSUptake
5545: AND party_site_id IN (
5546: SELECT party_site_id
5547: FROM hz_party_sites
5548: WHERE location_id = l_location_id
5549: AND party_id = l_merge_to_party_id );
5550:
5551: l_create_acct_site_use := 'Y';

Line 5574: FROM hz_party_sites ps

5570: --In case of there exist multiple party site on the address, we
5571: --pick up the one with mininum id (and same business purpose, if exists)
5572:
5573: SELECT MIN(party_site_id) INTO l_party_site_id
5574: FROM hz_party_sites ps
5575: WHERE party_id = l_merge_to_party_id
5576: AND location_id = l_location_id
5577: AND EXISTS ( --'same site usage'
5578: SELECT party_site_use_id

Line 5587: FROM hz_party_sites

5583: --No corresponding party site use. We need to create a new one.
5584: IF l_party_site_id IS NULL THEN
5585:
5586: SELECT MIN(party_site_id) INTO l_party_site_id
5587: FROM hz_party_sites
5588: WHERE party_id = l_merge_to_party_id
5589: AND location_id = l_location_id;
5590:
5591: l_create_party_site_use := 'Y';

Line 6529: FROM hz_party_sites

6525: WHERE site_use_id = l_customer_site_id;
6526: end if;
6527: --bug 3959776
6528: SELECT party_site_number INTO l_party_site_number
6529: FROM hz_party_sites
6530: WHERE party_site_id = ( SELECT party_site_id
6531: FROM hz_cust_acct_sites
6532: WHERE cust_acct_site_id = l_customer_address_id);
6533: UPDATE ra_customer_merges