APPS.HZ_MERGE_DUP_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 527: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;

523: WHERE ps.party_site_id = cp_ps_id
524: AND ps.location_id = l.location_id;
525:
526: CURSOR c_cust_site_check IS
527: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;
528:
529:
530: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;

Line 971: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;

967: WHERE ps.party_site_id = cp_ps_id
968: AND ps.location_id = l.location_id;
969:
970: CURSOR c_cust_site_check IS
971: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;
972:
973:
974: l_count NUMBER;
975: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;

Line 2403: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;

2399: FROM HZ_MATCHED_PARTY_SITES_GT
2400: WHERE search_context_id = l_search_context_id;
2401:
2402: CURSOR c_cust_site_check(p_from_entity_id NUMBER) IS
2403: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;
2404:
2405: --4114254
2406: CURSOR c_get_orig_system(p_party_site_id NUMBER) IS
2407: select o.orig_system

Line 4689: hz_cust_acct_sites_all as1,

4685:
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

Line 4702: hz_cust_acct_sites_all as2,

4698: and pd1.merge_from_entity_id = ps1.party_site_id
4699: and pd1.merge_from_entity_id <> pd1.merge_to_entity_id
4700: AND exists
4701: ( select 1 from hz_party_sites ps2,
4702: hz_cust_acct_sites_all as2,
4703: hz_merge_parties p2,
4704: hz_merge_party_details pd2
4705: where p2.batch_id = p_merge_batch_id
4706: and ps2.party_site_id = as2.party_site_id

Line 4737: hz_cust_acct_sites_all as1,

4733:
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

Line 4750: hz_cust_acct_sites_all as2,

4746: and pd1.merge_from_entity_id = ps1.party_site_id
4747: and pd1.merge_from_entity_id <> pd1.merge_to_entity_id
4748: AND exists
4749: ( select 1 from hz_party_sites ps2,
4750: hz_cust_acct_sites_all as2,
4751: hz_merge_parties p2,
4752: hz_merge_party_details pd2
4753: where p2.batch_id = p_merge_batch_id
4754: and ps2.party_site_id = as2.party_site_id