APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on AP_DUPLICATE_VENDORS_ALL

Line 1533: FROM ap_duplicate_vendors_all

1529: * R12 Perf Bug 4949639 : Do not need this cursor any more
1530: * since we rely on the parameter p_calling_mode
1531: CURSOR check_option IS
1532: SELECT process
1533: FROM ap_duplicate_vendors_all
1534: WHERE vendor_id = p_to_id
1535: AND vendor_site_id = p_to_site_id
1536: AND duplicate_vendor_id = p_from_id
1537: AND duplicate_vendor_site_id = p_from_site_id;

Line 1594: FROM ap_duplicate_vendors_all

1590: AND wdd.ship_from_site_id <> p_to_site_id
1591: AND wdd.vendor_id = p_from_id
1592: AND nvl(wda.type,'S') IN ('S' , 'O')
1593: AND NOT EXISTS (SELECT 1
1594: FROM ap_duplicate_vendors_all
1595: WHERE process_flag IN ('S', 'D')
1596: AND process IN ('P','B')
1597: AND duplicate_vendor_id = wdd.vendor_id
1598: AND duplicate_vendor_site_id = wdd.ship_from_site_id