APPS.HZ_MERGE_DUP_PVT dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 2371: from HZ_MATCHED_PARTY_SITES_GT mps

2367: -- need to check if the matched addr is already mapped by other sites
2368: -- therefore, check if the site_id = merge_to_entity_id
2369: cursor get_suggested_addr(l_search_ctx_id NUMBER, l_master_site NUMBER) is
2370: select party_site_id
2371: from HZ_MATCHED_PARTY_SITES_GT mps
2372: where mps.search_context_id = l_search_ctx_id
2373: and mps.party_site_id <> l_master_site
2374: and not exists
2375: ( select 1

Line 2398: FROM HZ_MATCHED_PARTY_SITES_GT

2394: and mpd.entity_name = 'HZ_PARTY_SITES';
2395:
2396: CURSOR c_get_matched_ps(l_search_context_id NUMBER) IS
2397: SELECT party_site_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;

Line 2524: DELETE FROM HZ_MATCHED_PARTY_SITES_GT

2520: l_return_status,
2521: l_msg_count,
2522: l_msg_data);
2523: IF l_merge_yn = 'N' THEN
2524: DELETE FROM HZ_MATCHED_PARTY_SITES_GT
2525: WHERE search_context_id = l_search_ctx_id
2526: AND party_site_id = l_temp_from_site;
2527: l_num_matches := l_num_matches - 1;
2528: END IF;

Line 2553: DELETE FROM HZ_MATCHED_PARTY_SITES_GT

2549:
2550: IF (c_get_orig_system%FOUND AND l_to_orig_system <> l_from_orig_system) OR
2551: (c_get_orig_system%NOTFOUND) THEN
2552:
2553: DELETE FROM HZ_MATCHED_PARTY_SITES_GT
2554: WHERE search_context_id = l_search_ctx_id
2555: AND party_site_id = l_temp_from_site;
2556:
2557: l_num_matches := l_num_matches - 1;

Line 2584: FROM HZ_MATCHED_PARTY_SITES_GT matchps

2580: FROM HZ_MERGE_PARTIES_SUGG
2581: WHERE batch_id = p_batch_id )
2582: AND merge_from_entity_id IN
2583: ( SELECT party_site_id
2584: FROM HZ_MATCHED_PARTY_SITES_GT matchps
2585: , HZ_MERGE_PARTYDTLS_SUGG mpd
2586: , HZ_MERGE_PARTIES_SUGG mps
2587: WHERE matchps.search_context_id = l_search_ctx_id
2588: AND matchps.party_site_id = mpd.merge_from_entity_id

Line 2633: -- find out all matched sites from HZ_MATCHED_PARTY_SITES_GT

2629: ,x_msg_data => l_msg_data
2630: );
2631:
2632: IF (l_num_matches > 0) THEN
2633: -- find out all matched sites from HZ_MATCHED_PARTY_SITES_GT
2634: OPEN get_suggested_addr(l_search_ctx_id, l_master_site);
2635: LOOP
2636: FETCH get_suggested_addr into l_merge_from_site;
2637: EXIT WHEN get_suggested_addr%NOTFOUND;