DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_CUST_ACCOUNTS

Line 4687: hz_cust_accounts ca1,

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

Line 4735: hz_cust_accounts ca1,

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