APPS.ARP_CMERGE_ARCUS dependencies on HZ_PARTY_SITE_USES

Line 5251: FROM hz_party_site_uses su

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
5251: FROM hz_party_site_uses su
5252: WHERE su.party_site_id = ps.party_site_id
5253: AND site_use_type = l_duplicate_site_code );
5254:
5255: --No corresponding party site use. We need to create a new one.

Line 5285: from hz_party_site_uses

5281:
5282: -- Build party site use record.
5283:
5284: select party_site_use_id into l_duplicate_party_site_use_id
5285: from hz_party_site_uses
5286: where site_use_type = l_duplicate_site_code
5287: and party_site_id = l_duplicate_party_site_id
5288: and ROWNUM=1;
5289:

Line 5579: FROM hz_party_site_uses su

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
5579: FROM hz_party_site_uses su
5580: WHERE su.party_site_id = ps.party_site_id
5581: AND site_use_type = l_duplicate_site_code );
5582:
5583: --No corresponding party site use. We need to create a new one.

Line 5607: from hz_party_site_uses

5603:
5604: -- Build party site use record.
5605:
5606: select party_site_use_id into l_duplicate_party_site_use_id
5607: from hz_party_site_uses
5608: where site_use_type = l_duplicate_site_code
5609: and party_site_id = l_duplicate_party_site_id
5610: and ROWNUM=1;
5611: