APPS.HZ_ACCOUNT_MERGE_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 529: FROM hz_cust_site_uses_all

525: ) IS
526:
527: CURSOR get_site_use_details(c_site_use_id NUMBER) IS
528: SELECT site_use_id, cust_acct_site_id, site_use_code, status, location, primary_flag
529: FROM hz_cust_site_uses_all
530: WHERE site_use_id = c_site_use_id;
531:
532: l_site_use_id NUMBER;
533: l_account_site_id NUMBER;

Line 593: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL');

589: -- Get how many rows return
590: l_count := HZ_MOSR_VALIDATE_PKG.get_orig_system_ref_count(
591: p_orig_system => p_site_use_os,
592: p_orig_system_reference => p_site_use_osr,
593: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL');
594:
595: IF (l_count = 0) THEN
596:
597: FND_MESSAGE.SET_NAME('AR','HZ_CM_INV_OSOSR');

Line 607: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',

603: -- Get owner_table_id
604: HZ_ORIG_SYSTEM_REF_PUB.get_owner_table_id(
605: p_orig_system => p_site_use_os,
606: p_orig_system_reference => p_site_use_osr,
607: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
608: x_owner_table_id => l_owner_table_id,
609: x_return_status => x_return_status);
610:
611: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 822: FROM hz_cust_site_uses_all

818: WHERE party_id = c_party_id;
819:
820: CURSOR c_site_use(c_acct_site_id NUMBER) IS
821: SELECT 'Y'
822: FROM hz_cust_site_uses_all
823: WHERE cust_acct_site_id = c_acct_site_id
824: AND rownum = 1;
825:
826:

Line 1794: FROM hz_cust_site_uses_all use,hz_cust_acct_sites_all site

1790: WHERE m.customer_merge_header_id = l_header_id
1791: AND m.customer_createsame = 'Y'
1792: AND m.duplicate_site_id <> -99
1793: AND exists (SELECT 'Y'
1794: FROM hz_cust_site_uses_all use,hz_cust_acct_sites_all site
1795: WHERE site.cust_account_id = m.customer_id
1796: AND site.org_id = m.org_id --SSUptake
1797: AND site.cust_acct_site_id = use.cust_acct_site_id
1798: AND site.org_id = use.org_id --SSUptake