APPS.ARP_CMERGE_ARCUS dependencies on HZ_PARTY_SITE_USES

Line 5566: FROM hz_party_site_uses su

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
5566: FROM hz_party_site_uses su
5567: WHERE su.party_site_id = ps.party_site_id
5568: AND site_use_type = l_duplicate_site_code );
5569:
5570: --No corresponding party site use. We need to create a new one.

Line 5600: from hz_party_site_uses

5596:
5597: -- Build party site use record.
5598:
5599: select party_site_use_id into l_duplicate_party_site_use_id
5600: from hz_party_site_uses
5601: where site_use_type = l_duplicate_site_code
5602: and party_site_id = l_duplicate_party_site_id
5603: and ROWNUM=1;
5604:

Line 5907: FROM hz_party_site_uses su

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
5907: FROM hz_party_site_uses su
5908: WHERE su.party_site_id = ps.party_site_id
5909: AND site_use_type = l_duplicate_site_code );
5910:
5911: --No corresponding party site use. We need to create a new one.

Line 5935: from hz_party_site_uses

5931:
5932: -- Build party site use record.
5933:
5934: select party_site_use_id into l_duplicate_party_site_use_id
5935: from hz_party_site_uses
5936: where site_use_type = l_duplicate_site_code
5937: and party_site_id = l_duplicate_party_site_id
5938: and ROWNUM=1;
5939: