DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_CUST_ACCOUNTS

Line 4690: hz_cust_accounts ca1,

4686: cursor acct_site_merge_required_csr is
4687: SELECT 'Y'
4688: FROM hz_party_sites ps1,
4689: hz_cust_acct_sites_all as1,
4690: hz_cust_accounts ca1,
4691: hz_merge_parties p1,
4692: hz_merge_party_details pd1
4693: WHERE p1.batch_id = p_merge_batch_id
4694: AND ps1.party_site_id = as1.party_site_id

Line 4738: hz_cust_accounts ca1,

4734: CURSOR check_site_merge_csr IS
4735: SELECT distinct ca1.account_number, pd1.merge_to_entity_id
4736: FROM hz_party_sites ps1,
4737: hz_cust_acct_sites_all as1,
4738: hz_cust_accounts ca1,
4739: hz_merge_parties p1,
4740: hz_merge_party_details pd1
4741: WHERE p1.batch_id = p_merge_batch_id
4742: AND ps1.party_site_id = as1.party_site_id