APPS.CHV_VENDORMERGE_GRP SQL Statements

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

Line: 50

         UPDATE CHV_SCHEDULE_HEADERS
         SET    vendor_id      = p_vendor_id,
                vendor_site_id = p_vendor_site_id
         WHERE  vendor_id      = p_dup_vendor_id
         AND    vendor_site_id = p_dup_vendor_site_id ;

Line: 65

	 FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 72

         UPDATE CHV_CUM_ADJUSTMENTS
         SET    vendor_id      = p_vendor_id,
             	vendor_site_id = p_vendor_site_id
         WHERE  vendor_id      = p_dup_vendor_id
         AND    vendor_site_id = p_dup_vendor_site_id ;

Line: 87

	FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);