APPS.HZ_MERGE_DUP_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

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

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

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

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

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

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

Line 4686: hz_cust_acct_sites_all as1,

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

Line 4699: hz_cust_acct_sites_all as2,

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

Line 4734: hz_cust_acct_sites_all as1,

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

Line 4747: hz_cust_acct_sites_all as2,

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