APPS.IGC_VENDOR_MERGE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 56

     UPDATE po_headers
     SET    vendor_id         = p_new_vendor_id,
            vendor_site_id    = p_new_vendor_site_id,
            last_update_date  = SYSDATE,
            last_update_login = FND_GLOBAL.login_id,
            last_updated_by   = FND_GLOBAL.user_id
     WHERE  vendor_id         = p_old_vendor_id
     AND    vendor_site_id    = p_old_vendor_site_id
     AND    segment1          IN (SELECT cc_num
                                  FROM   igc_cc_headers
                                  WHERE  org_id            = g_org_id
                                  AND    vendor_id         = p_old_vendor_id
                                  AND    vendor_site_id    = p_old_vendor_site_id);

Line: 70

     UPDATE igc_cc_headers
     SET    vendor_id         = p_new_vendor_id,
            vendor_site_id    = p_new_vendor_site_id,
            last_update_date  = SYSDATE,
            last_update_login = FND_GLOBAL.login_id,
            last_updated_by   = FND_GLOBAL.user_id
     WHERE  vendor_id         = p_old_vendor_id
     AND    vendor_site_id    = p_old_vendor_site_id
     AND    org_id            = g_org_id;